Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Did you ever work out a solution to this?
There is a hint exists. Add static but relevant object into Tooltips and sort by it. It won't reset.
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
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
91 | |
51 | |
49 | |
46 |