Posts filed under Intermediate

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

Ranking by Multiple Columns (Guest Post by BI Elite)

Video by: Parker Stevens

BI Elite YouTube Channel

Today's video is a guest post from Parker over at BI Elite. Parker has generously agreed to do a guest video for my channel, where he'll explain how to use DAX to create a ranking based on multiple columns. So give it a watch and see how quickly and easily it can be done.

Posted on January 8, 2019 and filed under Intermediate, Power BI.

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.

Extracting Multiple Tables From A Power Query Combine Folder Source

Video by: Reid Havens

One of the amazing data connectors in Power Query is the ability to combine files from a folder. However, what happens when those files each contain multiple tables you'd want to combine? This video covers a simple technique to extract multiple tables from each file, using the folder combine data connector.

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