Removing 0 from the waterfall chart in powerBI

[shahnaz0794]

Hi Team

I am working on the waterfall chart in the powerBI and I can see 0 values in the bridge bars.I want to remove them from the display.Can someone help me out how to do the same.

Thank you

Shahnaz

[Anonymous]

i have the same doubt but as far as i can find, no solutions till date

[SamInogic]

Hi @shahnaz0794 ,

As per our understanding, you have plotted the data using a waterfall chart and you want to filter out the data having values greater than 0.

So, we have considered a sample Waterfall Chart with zero values as well. Please refer to the below screenshot.


We can apply a filter to the chart, select the chart and click on the Filter panel on the Power BI Report. Apply the filter as Value is greater than 0 and click on Apply Filter button.

This will filter out the zero-value data from your chart as shown in the below screenshot.

If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[shahnaz0794]

Hi

Thank you for the response,

But this doesnot answer my concern.

Let me put it again!

The waterfall chart shows the comparison between the two time periods. But in the actual object of waterfall chart does not have any option to remove resultant 0 values and it eats up lot of chart space.

It is good to have an option to filter on the resultant values.

Thank you in advance for the valuable suggestions.