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."