Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

conditional background color for specific complete columns in the matrix

Hi, I want the background color for complete 3 columns in my matrix in this way as shown below where my condition would be like- if Table(percentage) = "D(75-90%)" then "yellow" and so on. But I'm n...
data protection
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Originally I'm not using any measure. I'm just using count of a column in values as you can see in the below image. So I am not able to create this measure you talked about:

no blanks measure = [your measure] + 0

 

 

 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Use a measure instead.

Count Tasks = COUNT(table[Task]) 

and take it from there

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    No change in the result even after I add 0 to measure. Its not replacing the blank cells.