DAX Measures: Sparklines and Small Multiples in Power BI

BRIAN GRANT (SkyPoint CSG) – 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.

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.