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 box’ visualizations in Power BI. You can create a significant amount of visualizations by using the powerful DAX formula language.
Your options are virtually unlimited; it’s all up to your imagination, and how you utilize the blank report/canvas you have at your disposal.
Using dynamic visuals, especially on ranking based parameters, means you can really drill into the key driver of an attribute’s performance. You may want to isolate your top and bottom customers, or your best and worst selling products. This technique would enable you to visually showcase all of these ideas.
To make this come alive we need to use RANKX within the CALCULATE statement. Get a good understanding of how these fit together and it will help with the more technical aspects of implementing DAX measures inside your models. It’s where you want to get to so that you can unleash the great analytical and also visual potential within Power BI. If you want to deep much deeper into how DAX works then you’ll want to investigate my advanced online course, Mastering DAX Calculations.
I’m hoping you’ll see the immense potential here with this video. As you watch it, look out for how you could integrate this into your own models effectively.
Good luck with this one.