Dynamic ranking with numeric parameters

The TopN feature can work with Power BI numeric range parameters, enabling you to easily perform what-if analysis. You just need to adjust the ranking slider to apply TopN.

You can set up dynamic ranking in 2 simple steps:

STEP 1: Assign the Power BI numeric range parameter to the Tooltip categories visual parameter.

STEP 2: In the TopN configuration window, select Measure from the By dropdown. Select the numeric range parameter name from the Measure dropdown. In this case, we've named the parameter 'RankingSlider'.

Setting up dynamic ranking

Notice how the axis categories change in response to the slider changes. Only the top-performing categories are displayed based on their rank.

Dynamic ranking in Analytics+ visuals

Last updated