Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to show the start value, breakdown and end values by a waterfall chart. I found a post showing how to do that.
Although I don't really understand the measure in the post, I copied it and it works well either between Aug 2020 and Dec 2020 or Dec 2021 and Dec 2022 but if I want to show all data in one graph between Aug 2020 and Dec 2022, it doesn't work.
Is it possible to show all data in one graph between Aug 2020 and Dec 2022 using that measure? or it only works between two period? Thanks!
My measure:
Hi , @qazwsxedc
It's possible to show all data in one graph between Aug 2020 and Dec 2022 .
Could you please share a sample filefor testing?
You can check whether the solution in these related threads help.
https://community.powerbi.com/t5/Desktop/Waterfall-chart-start-valu/m-p/1020967
Best Regards,
Community Support Team _ Eason
Thank you Eason! I have worked around to show the start and end values by waterfall. However, can I change the order of the breakdown? E.g. I would like the order to be Volume, Mix, Gross Revenue and Discounts i/o ordering by the breakdown's value.
The related PBI file is uplaoded. Could you please take a look? Thanks!
https://drive.google.com/file/d/1PnVcjE-e1dGA0OnGvGOUCbQURlcNQ0rD/view?usp=sharing
Hi, @qazwsxedc
Sorry,after my research ,I'm afraid it doesn't support it currently.
Even you drag the filed "Breakdown sort" to tooltip then sort by it , or sort column "Breakdown" by column "Breakdown sort" ,it will not affect the order of the breakdown in waterfall chart.
As of now, I couldn't find any workaroud.I would suggest to create a support ticket to PowerBi Support Team.Maybe they will have better advice.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |