Forum Discussion
Sorting Bar Chart Axis When using Two Field Parameters
I have a bar chart that is using a Field Parameter on both the Y and X Axis. I would like to always sort the bar chart on the x axis, no matter what is selected on the Y axis field parameter. But everytime I make a new selection on the Y axis field parameter, it defaults to sorting based on the Y axis.
In the Example below, I want to always sort the Axis to be Americas, EMEA, APAC, Other Global, EOC. When select an X axis parameter, I can get the graph to do this no matter whant I select on the Y axis, but when i select a new level or the hierarchy, say business group, it defaults back to sorting based on the Y axis value. How do I make the graph always sort on the X Axis Selection?
Any help is appreciated
Hi jrich_1995
I don't think that there is a way to lock the sorted axis, in case you use field parameters for everything.
You can suggest this as the idea here :
https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=lock%20sorted%20axis%20when%20using%20field%20parametrs
(I saw some talking about similar problems, so maybe you just have to vote for one of them).
As an alternative if the issue is critical you can use bookmarks that show and hide visuals.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
1 Reply
Hi jrich_1995
I don't think that there is a way to lock the sorted axis, in case you use field parameters for everything.
You can suggest this as the idea here :
https://ideas.fabric.microsoft.com/ideas/search-ideas/?q=lock%20sorted%20axis%20when%20using%20field%20parametrs
(I saw some talking about similar problems, so maybe you just have to vote for one of them).
As an alternative if the issue is critical you can use bookmarks that show and hide visuals.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly