Field Parameters and Sorting based on measure

[Anonymous]

Hi, 
I am using Field parameters in a drop down and the chart to change accordingly to the dropdown. The chart is a ranking chart(Clustered bar chart) and I want to sort the chart based on the measure selected from the field parameters in descending order. Every time I choose a different value in dropdown my sort will be reset as it as different measure. Is there a work around for this?. Eg. write a new measure to always sort by the selected measure in descending order and use it in the chart.

PS, I do not want to deviate from field parameters and use another alternatives to change the chart dynamically with the dropdown selection.

[RicoZhou2]

Hi @Anonymous ,

Did you create a dynamic Xaxis which is filtered by slicer? As far as I know, if you sort the visual by column in X aixs, Power BI will change the sort dynamiclly.

Here I create a sample.

Measure:

Measure = 
SWITCH(SELECTEDVALUE('Combine Table'[Category]),
"Region",CALCULATE(SUM(Data[Value]),USERELATIONSHIP(Data[Region],Region[Region])),
"Year",CALCULATE(SUM(Data[Value]),USERELATIONSHIP(Data[Year],'Year'[Year])))

Result is as below.

Best Regards.

[Anonymous]

Hi @RicoZhou2 ,

My slicer has various measures(field parameters) used in the chart, not the columns and I am the measures for the X-axis of a clustered bar chart. I see that your solution is using column to sort not the measures.

[amitchandak]

@Anonymous , Once I sort it on a measure it always remains in that, even when I change that

[amitchandak]

@Anonymous , Once I sort it on a measure it always remains in that, even when I change that

[Anonymous]

Hi @amitchandak , 

Not sure what was done wrong in my case, I am unable to sort by the measure. each time I select another measure, the sorting for the Y-axis is being reset.I found a similar question here, https://community.powerbi.com/t5/Desktop/Sort-Visual-on-Field-Parameter/m-p/2520955

[AnetaK]

I have the same issue.

Whenever I select something in the slicer, the sorting is off and I have to set it once again.

Did you find any solution for that?