Waterfall chart issues with Sorting and Other category

[Anonymous]

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

Expected chart

Current developed chart

Request your help asap

Regards,

Shivanand

[v-frfei-msft]

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

[Anonymous]

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

[Anonymous]

and also Actual and Planned are interchanged the place