Dynamic ranking with numeric parameters
Last updated
Last updated
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'.
Notice how the axis categories change in response to the slider changes. Only the top-performing categories are displayed based on their rank.
