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
what about indicating 'Y" and N ?
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")
sir ,if(isblank([measure], "Y", "N") ,what is the measure here ?
ashik1992 , you have shown a matrix above, what was the value there. Using that as a measure
im getting an error that too many arguments passed.
Flag measure = if(isblank('project'[daycount], "Y", "N"))