Forum Discussion
Y-Axis Parameter Sorting
I'm using a parameter with a slicer to show/hide columns on a cluster column chart, this is working really well, however when the user removes a column and later adds it again it get appended to the end rather than having a sort order.
Quarters = {
("Q3 2023", NAMEOF('Results'[Q3 2023]), 0),
("Q4 2023", NAMEOF('Results'[Q4 2023]), 1),
("Q1 2024", NAMEOF('Results'[Q1 2024]), 2)
}
Of course if these were static fields I could just re-order them in the build visual tray but given that there is only my parameter in there now how can I utilise the sort order at the top level?
If I go to the sort Axis on the visual I get the following fields:
- X Axis
- Q3 2023
- Q1 2024
- Q2 2024
But I want to step a level up and sort those quarters.
For those looking to sort the Axis this video really helped by using the Tooltips and I'm sure there must be a way to do a simular thing with the Y axis, https://www.youtube.com/watch?v=GfBrB6czByw
- Anonymous2 years ago
Hi trevrobwhite2 ,
I'm not quite sure what that means, but maybe you can try using sort by column:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Hi trevrobwhite2 ,
I'm not quite sure what that means, but maybe you can try using sort by column:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.