Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
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
Solved! Go to Solution.
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 Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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 Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.