Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shahnaz0794
Regular Visitor

Removing 0 from the waterfall chart in powerBI

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

3 REPLIES 3
MrinaalRaj
New Member

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

SamInogic
Super User
Super User

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.

Zero Value.png
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.

Apply Filter.png

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

OutputAnswer.png

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/

Inogic Professional Services: Power Platform/Dynamics 365 CRM
An expert technical extension for your techno-functional business needs
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Tips and Tricks: https://www.inogic.com/blog/

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.

shahnaz0794_0-1681981796065.png

Thank you in advance for the valuable suggestions.

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.