Tag: DAX

Find Out How To Quickly Create Virtual Groups In Power BI

Did you know there is a way to create groups virtually in Power BI? I was so happy when I discovered this, as it allows you to quickly and effectively create another grouping dimension in your datasets or data tables. The Power BI team has made it so easy to implement and edit as well.

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking. This is a really powerful technique that you can utilize in Power BI. Never think you are limited to the standard ‘out of the

Continue reading

Layering Multiple Scenarios Analysis Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading

Explore Forecasting Logic In Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading

Cumulatively Compare Information Over Different Months

Showcasing your results cumulatively is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When you place

Continue reading