CLUSTERED BAR CHART based on parametric measurement

[Br1-981]

Hi,

I've created a clustered basr chart with horizontal bars and labels moved into a fake dimension:

The measurement is based on a parameter (3 different measurements), the problem is that I want bars always ordered as descending based on metric (that could change based on the parameter) and ordering it manually does not take in memory and every time I have to change it manually and it resets to countries when i change parameters.
Any idea?

[Daniel29195]

@Br1-981 

refere also to this : 

https://community.fabric.microsoft.com/t5/Desktop/Sorting-on-Parameter-fields-measures/m-p/2855224

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

[Daniel29195]

@Br1-981 

we had the same issue, and unfortunately we didnt find a straightforward solution for this. 

if the parameter have like 2 measures only, i would suggest to create 

2 buttons which change between the 2 bookmarks . where each bookmark display the required measure . 

if the nb of measures in the parameter is big, i dont think there is a solution to dynamically change the order base on the change of the measure. 

found this : 

https://eriksvensen.wordpress.com/2023/08/09/powerbi-control-the-sorting-when-using-a-field-paramete...

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍
 

[Br1-981]

The problem is that I'm using the parameter to pilot the dimensions of the whole page