Tag: Data visualisation

Prevent YTD, QTD, MTD Results Extending Forward In Power BI

Recently I had a unique question pop up at the Enterprise DNA Support Forum. In this scenario, we are looking to evaluate YTD sales but we don’t want to evaluate anything past the last sale that may have occurred. We only want to show the cumulative YTD total up to the last sale. This is

Continue reading

SWITCH True Logic Explained For Power BI

When utilizing SWITCH/True Logic inside of Power BI you really do open up this huge expanse of analytical opportunities. In this tutorial, I will run through in detail 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

Continue reading

Dynamic Report Technique For Power BI

In this tutorial, I will show you how you can create a totally dynamic Power BI report. When I say dynamic, what I mean is that you may want to showcase one particular insight across all of your visualizations in your report page, but then you might want to be able to select a different

Continue reading

Shape Map Visualizations For Spatial Analysis In Power BI

The Shape Map Visualization is probably my most favorite map visualization inside of Power BI. I think it blends in well inside of reports and dashboards. It actually looks a lot better on a report than if you’ll just use the standard map feature. It also has other great visualization features like Drill In, Drill

Continue reading

Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

In this tutorial, we are going to dive into on how to utilize the RANKX function effectively in Power BI. Sometimes you don’t want to show all of 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

Continue reading