- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
10-06-2024 07:29 AM | |||
09-24-2024 06:58 AM | |||
07-23-2024 07:37 AM | |||
04-19-2024 10:51 AM | |||
06-17-2024 04:19 AM |
User | Count |
---|---|
88 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
65 | |
54 | |
48 | |
45 |