Forum Discussion
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 order and also linked that order to the measures.
For the life of me I can not figure out how to get the Qs to line up in order.
Dropbox Link: https://www.dropbox.com/scl/fi/3lq1pikai7wvkk28mqaw0/I-hate-power-bi.pbix?rlkey=6fd6re00wvsxkc0c2tdqy8krr&st=zezdkk2b&dl=0
Anyhelp would be appreciated.
10 Replies
Hi,
In the attached file, i have simpified stuff. However, sincce there is no data for 2024 in the Q0Q change column of the Excel table, the waterfall chart does not display.
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
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.
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."
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.
I can not. It appears that we are not able to sort the quarters in my Power BI file.
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.
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.
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.
Hello Drisgoal,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
