Forum Discussion
conditional formatting
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
The closing bracket is in the wrong position. Use the following formula
Flag measure = if(isblank('project'[daycount]), "Y", "N")
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
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
I didnt understand your question? when you say 'apply both this measure' what do you mean?
What do you actually want to achieve?
i want to change the background color where cell cintais "Y" and "N"
Thank you so much sir