Posts filed under DAX

(Guest Post by BI Elite) Creating a Pareto Chart Using DAX in Power BI

Video by: Parker Stevens

Today's video is another guest post from Parker over at the BI Elite YouTube Channel. Parker will explain how to use some clever DAX measures with line and column combo chart in Power BI , to create a Pareto chart. A pareto chart is where the column values are individual values, and the line values are cumulative values. Learn this is accomplished in this video!

Posted on March 12, 2019 and filed under Custom Visuals, Intermediate, DAX.

SVG and GIF KPI's on Rows in Power BI Tables

Video by: Reid Havens

Given how much fun I had making the SVG sparklines in last weeks video. I thought I'd explore what other things I could do with the image rendering ability inside of Power BI tables. In this video you'll see that you can also render full SVG images, as well as animated GIFS using DAX.

SVG image converter I used to create the zelda hearts: Link

GIF creator I used to create the animated doom guy face: Link

SVG Image Sparklines on Rows in Power BI Tables

Video by: Reid Havens

With the recent update that allows tables in Power BI to render SVG images. We can now create interactive charts and sparklines directly inside of the tables. Learn how to leverage DAX to create well designed sparklines in this video.

Original post by David Eldersveld


Creating A KPI Scorecard Report: Part 3

Video by: Reid Havens

In this multi-part series you'll learn techniques utilizing DAXcustom visualizations, and design techniques to create a great looking KPI Scorecard report in Power BI.

Part Three will show you how to customize the cards with three colored states (red, yellow, green), and how to create a new set of KPI icons to correspond with these color states.

Relevant Links:

Creating A KPI Scorecard Report: Part 1

Creating A KPI Scorecard Report: Part 2

Creating A KPI Scorecard Report: Part 4

Blog Post: Mat Allington's UNICHAR DAX