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

Hi,

 

But I don't have any measure to put in (isblank([Measure]) since i'm using a column name of the table 'FinalManipulatedTable'[Percentage] to create this measure 'colour'.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , use min('FinalManipulatedTable'[Percentage]) in place of that and check.

 

What measure is displayed/used  in values of a matrix, use that