Forum Discussion

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

Icon for Community Champion rank

Community Champion

5 years ago

Anonymous

You can achive this be referencing the column directly in your measure. Here is an example in a matrix with "Channel" from (DIm Channel Table) are the columns and two measures for values (Sum of Sales and target)

Using this measure as for the conditional formatting:

Column colour = SWITCH(TRUE(),
    MAX('DIM Channel'[Channel]) = "B", "Red",
    MAX('DIM Channel'[Channel]) = "D", "Green")

Anonymous
Not applicable
5 years ago
Its giving weird results. Please see:

Am I missing something?
- PaulDBrown
  Community Champion
  5 years ago
  Anonymous
  
  OK, here is way to colour the blanks. First create a new measure to substitute blanks with 0 using a measure along the lines of:
  
  no blanks measure = [your measure] + 0
  
  In my example:
  
  Sum of Sales + 0 = [Sum of Sales] + 0
  
  Use this measure in the matrix and the measure for the conditional column. In my example:
  
  Column colour = SWITCH(TRUE(), MAX('DIM Channel'[Channel]) = "B", 1, MAX('DIM Channel'[Channel]) = "D", 2)
  
  And you will get this:
  
  If you want to show blanks instead of 0, create a new measure to use for the conditional formatting for the font referecning the original measure (which returns blanks):
  
  0 value condit column = SWITCH(TRUE(), AND(ISBLANK([Sum of Sales]), MAX('DIM Channel'[Channel]) = "B"), 1, AND(ISBLANK([Sum of Sales]), MAX('DIM Channel'[Channel]) = "D"), 2, ISBLANK([Sum of Sales]), 3)
  
  Now use this measure in the conditional formatting for the font:
  - Anonymous
    Not applicable
    5 years ago
    I don't know why but any measure is not replacing blanks with anything, even if I add 0. Thanks for the solutions though.

Related content