Forum Discussion
Power Bi Rank Function Not Staying Constant On Certain Slicers
Hi Anonymous , rajendraongole1 Thank you for your prompt reply!
Based on my testing, the Rank value will change based on the multislicer context.As a workaround, we can transform the data in Power Query, sort the TRD_COMMISSION_GBP columns in descending order, and then add index columns to make the sorting static:
In this way, we can see the difference between the original rank column and the index column:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , rajendraongole1 Thank you for your prompt reply!
Based on my testing, the Rank value will change based on the multislicer context.
As a workaround, we can transform the data in Power Query, sort the TRD_COMMISSION_GBP columns in descending order, and then add index columns to make the sorting static:
In this way, we can see the difference between the original rank column and the index column:
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.