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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
a10703
Helper I
Helper I

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
Responsive Resident
Responsive Resident

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
Helper I
Helper I

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
Helper I
Helper I

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

 

a10703_0-1648721819803.png

 

ITManuel
Responsive Resident
Responsive Resident

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

 

ITManuel
Responsive Resident
Responsive Resident

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.