cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Color the blank values apperaing in the Matrix visual?

I want to add a specific color to all the blank values that comes in my matrix table, now i am using 4 level of hirearchy and i want to add conditonal colors on all those blank values, a sample is given below where I need to add colors only to those values that are appearing as blank:

 

Screenshot (158)_LI.jpg

 

Any bright ideas how can I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Color the blank values apperaing in the Matrix visual?

Perhaps like the screen shot below? PBIX is attached.

 

image.png


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

6 REPLIES 6
Highlighted
Super User IX
Super User IX

Re: Color the blank values apperaing in the Matrix visual?

Perhaps like the screen shot below? PBIX is attached.

 

image.png


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Super User IX
Super User IX

Re: Color the blank values apperaing in the Matrix visual?

if the values are coming blank the create a measure like this

Color COGS= if(isblank(AVERAGE(Table[COGS])),"red","white")

 

The in conditional formatting under advance control choose the field and then choose this measure.

You have to create three measures(or one measure can handle all) and apply them to all the columns.

 

Refer :https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-based-on-a-calc...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Prodigy
Post Prodigy

Re: Color the blank values apperaing in the Matrix visual?

@Greg_Deckler Well in my case as you can see in the screenshot, I dont have any text fields in my value section and all of them contains a numerical field, please elaborate how can i achive in this scenerio?

Highlighted
Post Prodigy
Post Prodigy

Re: Color the blank values apperaing in the Matrix visual?

@amitchandak It does not works in my case and gives me everything in red and my blank fields are not coming as red.

Highlighted
Post Prodigy
Post Prodigy

Re: Color the blank values apperaing in the Matrix visual?

@Greg_Deckler I was able to twick the problem using your message. Thanks for the help.

Highlighted
Super User IX
Super User IX

Re: Color the blank values apperaing in the Matrix visual?

Great!


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors