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 ...
Need Help
Show and Tell
Tips and Tricks
PhilipTreacy's avatar
PhilipTreacy
Super User
9 months ago

Hi Drisgoal 

 

Please check this article about how to set up Waterfall Charts Waterfall Charts in Power BI - Power BI | Microsoft Learn

 

You should set up your Date Table and use that to create/store your quarters.  And you should be plotting a measure/value on the chart x axis.  As it is you have non-related data (no table relationships) being plotted that have no numeric value, at least not the ones you want.

 

Regards

 

Phil

 

Drisgoal's avatar
Drisgoal
Frequent Visitor
9 months ago

Thank you for your attempted help but this does not help.  

 

I have done everything that was stated in that article and this program will not sort by the Quarters. 

 

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    9 months ago

    Drisgoal 

     

    and have you done the other things I suggested?  

     

    "You should set up your Date Table and use that to create/store your quarters.  And you should be plotting a measure/value on the chart x axis.  As it is you have non-related data (no table relationships) being plotted that have no numeric value, at least not the ones you want."