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
BigKev
Helper III
Helper III

Showing 0% value in Tree map

Hi All,

 

I have encountered an issue where the Power BI Treemap does not show 0 value.

 

CategoryValue
A1.7%
B0.32%
C0 %

 

The treemap is showing category A & B and not C. I need category C to show in the treemaps, as I am using this treemap for the user to filter other measures.

 

Please help.

 

Cheers,

Kev

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @BigKev 

The Treemap won't work that way.  As it displays parts compared to the whole, but 0 is 0, so you are looking to have 0 represented by some value in order to see it in the Treemap.

Maybe another visual is what you are after.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @BigKev 

The Treemap won't work that way.  As it displays parts compared to the whole, but 0 is 0, so you are looking to have 0 represented by some value in order to see it in the Treemap.

Maybe another visual is what you are after.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


amitchandak
Super User
Super User

@BigKev , Add +0 to you measure

 

or try like 

divide([measure1], [measure2],0)

 

or

divide([measure1], [measure2],0)+0

 

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.