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
v-ssriganesh's avatar
v-ssriganesh
Community Support
9 months ago

Hi Drisgoal,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to PhilipTreacy & Ashish_Mathur for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.

  • Drisgoal's avatar
    Drisgoal
    Frequent Visitor
    9 months ago

    I can not.  It appears that we are not able to sort the quarters in my Power BI file.

    • v-ssriganesh's avatar
      v-ssriganesh
      Community Support
      9 months ago

      Hello Drisgoal,
      Sorry for the inconvenience, The Super User Ashish_Mathur is right the waterfall chart is currently blank because the underlying Excel table has no data at all for 2024 in the QoQ change column). The native Waterfall visual will not display anything if it doesn’t find any values to plot, even if the Breakdown table exists.

      Once you add the 2024 numbers into the Excel table and refresh, the chart will appear immediately.

  • Drisgoal's avatar
    Drisgoal
    Frequent Visitor
    8 months ago

    No I can not confirm since all the suggestions have not worked.  To be honest, I am very frustrated by Power BI and why something so that should be so easy is so difficult.  If you create a the same chart in Excel it works.... but not in power bi.  

    • v-ssriganesh's avatar
      v-ssriganesh
      Community Support
      8 months ago

      Hi Drisgoal,

      Sorry for the inconvince caused, If the issue still persists on your end, we recommend reaching out to our Power BI certified solution partners. These are highly experienced professionals who can provide in-depth technical assistance and offer tailored solutions based on your specific needs. You can explore the list of trusted partners here:

      Power BI Partners | Microsoft Power Platform

      You’re always welcome to continue engaging with the community as well,
      Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread.
      we truly appreciate your active participation in the Microsoft Fabric Community.