cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
a10703
Frequent Visitor

How to hide 0 fields on chart bar

Hi guys,

 

i hope you are doing well.

 

How can i hide the fields with 0 values?

 

 

a10703_0-1648634856238.png

 

My config:

a10703_1-1648634942653.png

Best regards.

 

 

3 ACCEPTED SOLUTIONS
ITManuel
Helper V
Helper V

Click on the hierarchy used for the shared X-Axis and undo the option "Show items with no data".

 

Best regards

View solution in original post

I have this option disabled 😕

 

a10703_0-1648637284566.png

 

View solution in original post

a10703
Frequent Visitor

Solved. In Visual Filter it's necessary to put >= 0  in this fields

 

a10703_0-1648721819803.png

 

View solution in original post

4 REPLIES 4
a10703
Frequent Visitor

Solved. In Visual Filter it's necessary to put >= 0  in this fields

 

a10703_0-1648721819803.png

 

ITManuel
Helper V
Helper V

Click on the hierarchy used for the shared X-Axis and undo the option "Show items with no data".

 

Best regards

I have this option disabled 😕

 

a10703_0-1648637284566.png

 

Maybe the zeros shown in the visual are not zeros in relatiy but only rounded to zero by the visual?

 

Not sure about that, but in this case you could apply filters in the measures in order to provide only values >= 0.5.

 

Br

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.