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
KarinSzilagyi's avatar
KarinSzilagyi
Super User
9 months ago

Hi Drisgoal please check the sorting on your visual itself (three dots > Sort axis > Quarter)

  • 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
)