conditional formatting

[ashik1992]

Hello Folks,

Im an beginner here . Need one help .

I have a matrix like this. in the row ,there is project details and states. in column there is day data. in value it is count of projects in respective sates.

I want to do  conditional formating .

condition is ,if there is blank cell,make the color grey and it is shown as "N" and if cell is not blank it should display in red color with "Y". Please help me to achieve it

Project details1	day1	day2	day3
Developemnt	12		14
testing	1513	13
ready			12
Project details2
Developemnt	3	5	7
testing		8
ready	45

[amitchandak]

@ashik1992 , Create a color measure like this and use that is conditional formatting with "Field value" Option

color measure =if(isblank([measure], "grey", "red") // where measure is measure you used values

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[ashik1992]

what about indicating 'Y" and N ?

[amitchandak]

@ashik1992 , Where you want to do that, You can have a measure and use that in the matrix

Flag measure =if(isblank([measure], "Y", "N")

[ashik1992]

sir ,if(isblank([measure], "Y", "N") ,what is the measure here ?

[amitchandak]

@ashik1992 , you have shown a matrix above, what was the value there. Using that as a measure

[ashik1992]

im getting an error that too many arguments passed.

Flag measure = if(isblank('project'[daycount], "Y", "N"))

[themistoklis]

@ashik1992 

The closing bracket is in the wrong position. Use the following formula

Flag measure = if(isblank('project'[daycount]), "Y", "N")

[ashik1992]

hello sir ,

how can we apply both this measure on same value ? example i need "Y" for all non blank values and background is green

[themistoklis]

@ashik1992 

I didnt understand your question? when you say 'apply both this measure' what do you mean?

What do you actually want to achieve?

[ashik1992]

i want to change the background color where cell cintais "Y" and "N"

[themistoklis · Accepted solution]

@ashik1992 

First you need to create 2 measures. One used in the matrix visual and the other that will be used in conditional formatting

Flag measure = if(isblank('project'[daycount]), "N", "Y")

Flag measure Conditional = if(isblank('project'[daycount]), "#CCCCCC", "#FF0010")

When you create the matrix visual, select the first measure from conditional formatting section.

Select 'Flag Measure' in conditional formatting section --> and on the pop up window --> select Format by (field Value) --> select the second measure (with the colours)

Image below

[ashik1992]

Thank you so much sir