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