Forum Discussion
Power BI WaterFall Sort Order
I am having difficulty finding a way to have my Quarters showing in Order for this Waterfall Chart.
I created two Data Tables for my Category and Breakdown
I created a sort order and also linked that order to the measures.
For the life of me I can not figure out how to get the Qs to line up in order.
Anyhelp would be appreciated.
15 Replies
HI Drisgoal ,
Did you create a custom sort order for your Quarters column? If yes, did you set-up sort by column on the table by Quarters column?
Something explained in the following article:
Hi Drisgoal please check the sorting on your visual itself (three dots > Sort axis > Quarter)
I did this too, it did not work.
Drisgoal Does your sort-column for the category look similar to this?
SortKey = SWITCH( TRUE(), 'Breakdown'[Time Period] = "Q1", 2, 'Breakdown'[Time Period] = "Q2", 3, 'Breakdown'[Time Period] = "Q3", 4, 'Breakdown'[Time Period] = "Q4", 5, 'Category'[Category] = "End of Last Year", 1, 'Category'[Category] = "Total - Current Year", 6 )
Hi Drisgoal
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi Drisgoal
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
Regards
