Forum Discussion
Sorting y axis ascending when using parameter measures
Hello dear Power BI Community.
I'm using a bar chart where the x axis is a regular field and y axis is a field parameter with 3 measures that I can switch with a slicer:
The default sort order of all measures is descending, but i want they to be ascending. When I set the to ascending using the 3 dots on the chart, it works fine. But if I switch to another measure it resets to descending again. Is this a bug? There is any workaround for sorting dynamically all measures?
I appreciate any help!
4 Replies
You should create a sorting column for the x-axis labeled and then put the desired numbers against each label in the new column after that click on sort by column and then select the product column and sort it with the new calculated column
Hi mh2587, thanks for the tip but that will work for the x-axis only. I want the y-axis asceding for all measures inside the field parameters.
There is a hint exists. Add static but relevant object into Tooltips and sort by it. It won't reset.
Did you ever work out a solution to this?
