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.
Hi,
I am working to show the Sales figures in Waterfall chart with Top 3 underperforming countries with Planned and actual. so i find Waterfall chart is ideal for this kind of visualization but i am unable to depict the same in proper manner because of the below issues: (Attached the expected chart and the current developed chart)
1.The issue of sorting – it is expected to have bars in order of - 1. Plan, 2. ascending order of sales of Top 3 negative growth countries next to each other and 3. the Actual. But when we change the sort order it is changing the position of plan (:Planned”) and Actual (“Actual”) as well
2.Conditional Formatting - Requirement is to change the color of “Others” bar to Red / Green (instead of default colors) depending on their sales figures but in Power BI the conditional formatting for “Others” category is not enabled
Request your help asap
Regards,
Shivanand
Hi @Anonymous ,
Please try to sort the visual like that.
We cannot set conditional formatting of the what fall chart as you request, You can come up a new idea and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
Thank you for your quick action and looking in to the issue in detail
I understand that the conditional formatting for 'Other' Categry is not available right now.
regarding the sorting, as you suggested i changes the 'sort by' to sales but the chart is showing top 3 gainers instead of losers (attached the chart screen for your reference
Regards,
Shivanand Bekinal
and also Actual and Planned are interchanged the place
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |