Forum Discussion
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 not able to do it using conditional formatting. Can someone tell the measure I should use?
When I'm using the measure:
COLOUR =
Please help!
13 Replies
- amitchandak
Super User
Anonymous , you need check blank for the measure too
,IF( FIRSTNONBLANK('FinalManipulatedTable'[Percentage] , 0) = "D(75-90%)" && (isblank([Mesure]) || not(isblank([measure]))) ,"yellow"
- amitchandak
Anonymous , use min('FinalManipulatedTable'[Percentage]) in place of that and check.
What measure is displayed/used in values of a matrix, use that
PaulDBrownCommunity Champion
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")- PaulDBrown
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] + 0Use 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:
