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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , you need check blank for the measure too

,IF( FIRSTNONBLANK('FinalManipulatedTable'[Percentage] , 0) = "D(75-90%)"  && (isblank([Mesure]) || not(isblank([measure]))) ,"yellow"

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'.