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:
Any bright ideas how can I do this?
Solved! Go to Solution.
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.
@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?
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.