Using Dynamic Visuals On Ranking Based Parameters In Power BI

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 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.

***** Learning Power BI? *****
All Enterprise DNA TV Resources
FREE COURSE – Ultimate Beginners Guide To Power BI
FREE COURSE – Ultimate Beginners Guide To DAX
FREE – 60 Page DAX Reference Guide Download
FREE – Power BI Resources
Enterprise DNA Membership
Enterprise DNA Online

***Learn more about Enterprise DNA Membership***membership banner 3

3 comments on “Using Dynamic Visuals On Ranking Based Parameters In Power BI”

  1. More great info Sam! Is there a way to simply add a column to a table that represents each row number in the table? In other words, the value is NOT related to any table data and always returns the same results regardless of filtered dimensions, specific column sort ordering, etc. It is simply the number of the row as it is rendered.


      1. Thanks for the prompt response. Actually, an index column doesn’t work for this purpose because it is specific to the record (row). The column value should ALWAYS equal the row number of the record in the table, regardless of how the table is sorted/filtered, etc. (like the ROWNUMBER function in Excel?)

        I’ll keep trying on my own – I’m sure you’re busy enough! Thanks again!



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s