Forum Discussion
Solved
conditional formatting
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 respe...
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")