Tag: Data visualisation

Show Top Or Bottom Results Using Ranking In Power BI

In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI. Sometimes you don’t want to show all the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the bottom seven. To

Continue reading

Advanced Power BI: How To Create Multi Threaded Dynamic Visuals

In this post, I want to show you what is, without a doubt, one of the most compelling visualization techniques in Advanced Power BI. Never feel you are confined to use just the general visualization options inside Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even

Continue reading

Preventing Year To Date Results From Projecting Forward

Today, I’m going to go over a solution for a certain issue regarding Year to Date (YTD) calculations. This actually stemmed from a question in the Enterprise DNA Support Forum. I’ll leave a link below to the forum discussion if you’d want to review it. You can view this forum post here – YTD Showing

Continue reading

How To Create Automated & Dynamic Power BI Reports

In this blog, I go over a really incredible development technique and concept on creating dynamic Power BI reports. This is actually taken from a session from a members-only event that I put on through Enterprise DNA, which was centered around financial reporting templates. In this tutorial, I want to go deeper into dynamic reporting

Continue reading

How To Use SWITCH True Logic In Power BI

When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights within Power BI. There

Continue reading