Posts filed under Intermediate

(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

Power BI Nested Date Sorting by Group Custom Column

Video by: Reid Havens

Power BI doesn't provide any native ways to created a nested sort order on tables. In this video learn how to create a nested date sort order column in the power query editor. Also learn how to use that as a hidden column in either table types in Power BI to create a custom sort order.

Posted on December 14, 2018 and filed under Intermediate, Power Query.