Forum Discussion

Drisgoal's avatar
Drisgoal
Frequent Visitor
9 months ago

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 ord...
General Comment
Need Help
Drisgoal's avatar
Drisgoal
Frequent Visitor
9 months ago

I did this too, it did not work.  

 

KarinSzilagyi's avatar
KarinSzilagyi
Super User
9 months ago

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
)