How to get rid of 'Others' in Water fall chart?

[Prash546]

Hello Team,

I have create water fall chart all the bars are coming as expected, apart from increase, decrease and total I am getting another bar/indicator as Others highlighted in yellow which is wrong? any way to get rid of this ?

[v-easonf-msft · Accepted solution]

Hi, @Prash546 

Power BI uses the value in Breakdown to add additional data to the visualization.

If you have use a field  in "Breakdown" of Water fall chart , you'd better to check  the MAX breakdowns.

In my case, I set the value of MAX breakdown to 11 , so each category will has at most 11 data points (bar)  instead of just one. Other datapoints (if it exists other datapoint) in category will naturally be classified as "other" .

For more details ,pleasae refer to this documnet.

power-bi-visualization-waterfall-charts 

Best Regards,
Community Support Team _ Eason