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
Rostanga
Frequent Visitor

Color formatting a cell with zero value in a decomposition tree visual

I have a decomposition tree set up and have conditional formatting on the values so they turn either red or green if one of the columns is yes or no.

 

Then i have a count of people in another column.  The problem that I have is that in the cells that are zero, it stays grey.  I want it to go red.   Is there a way around it.

  • I've tried to add in an IF statement before my SWITCH statement to try and make it red, but still won't change.

 

Here is my conditional format code I used in the measure. 

 

Colour Code Measure = IF (
ISBLANK('datasource'[Measure]),"Red",
(SWITCH(
TRUE(),
SELECTEDVALUE('datasource'[Yes/No]) = "Yes", "Green",
SELECTEDVALUE('datasource'[Yes/No]) <> "Yes", "Red"
))
)

 

20231128_134530.jpg

7 REPLIES 7
Rostanga
Frequent Visitor

I did a bandaid fix for this.  I changed the base colour to the same red, since all of the ones with no values would be a no anyways.  

parry2k
Super User
Super User

@Rostanga where are you using yes/no column?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

20231128_161421.jpg

This is the set I created for this sample decomp tree.  Just kept it small.

 

The yes/no column is only used in the measure that was created for the colour coding of the data boxes in the tree

parry2k
Super User
Super User

@Rostanga try this:

 

Colour Code Measure =
IF (
    [Measure] = 0,
    "Red",
    (
        SWITCH (
            TRUE (),
            SELECTEDVALUE ( 'datasource'[Yes/No] ) = "Yes", "Green",
            SELECTEDVALUE ( 'datasource'[Yes/No] ) <> "Yes", "Red"
        )
    )
)


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Unfortunately still staying grey.

parry2k
Super User
Super User

@Rostanga are you forcing measure to show 0 instead of blank ()?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k  the data source has zero's in it.

If i put those as null in power query then they disappear completely from the visual. 

But i need them to show as zero, but then as those would be non-compliant (or they are a no), I need those to also show as red.  I only want the ones that are yes to be green.   

I haven't added any other parts to the measure to force it. 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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