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
im getting an error that too many arguments passed.
The closing bracket is in the wrong position. Use the following formula
Flag measure = if(isblank('project'[daycount]), "Y", "N")
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
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
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