Forum Discussion
Field Parameters and Sorting based on measure
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.
6 Replies
Anonymous , Once I sort it on a measure it always remains in that, even when I change that
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
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?
Anonymous , Once I sort it on a measure it always remains in that, even when I change that
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.
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.
