DAX Measures: Sparklines and Small Multiples in Power BI

BRIAN GRANT (CSG Pro) – DAX Measures: Sparklines and Small Multiples in Power BI


Most Power BI users are aware that DAX unlocks the ability to create incredible dynamic calculations within reports; most though, are unaware that you can even use DAX to generate images using the SVG (Scalable Vector Graphics) standard. This means the long sought-after chart types of “small multiples” and “spark lines” are suddenly available, letting report authors create pivot tables, not of numbers, but of dozens of tiny dynamic charts. However, this only works if you know how to leverage DAX to write dynamic SVG code, a rather oblique use of the language. In this session we’ll be showing users how to do exactly that step by step, live on stage. Folks will walk away with basic patterns they can use to create their own chart measures at home in no time at all.

This session was recorded at the Pacific Northwest Power BI Symposium 2019 on 6/18/19.

Portland Power BI User Group

Portland Power BI User Group

The Portland Power BI User Group is a community of people excited about the business analytics tool, Power BI. We believe the platform offers rich possibilities, and we keep pace by sharing our learning and doing deep-dive explorations of topics. We run the gamut from new to experienced users and welcome anyone who shares an interest in data analytics. Some great perks to joining our monthly meetups are networking, knowledge transfer, and community building. We aim to foster a vibrant community that shares success in implementing best practices for Power BI. Complimentary pizza and refreshments are served at every meetup.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?