Forum Discussion
conditional background color for specific complete columns in the matrix
Its giving weird results. Please see:
Am I missing something?
Community ChampionAnonymous
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:
I don't know why but any measure is not replacing blanks with anything, even if I add 0. Thanks for the solutions though.
- PaulDBrown
Anonymous
Can you show the DAX for the original measure and the + 0 measure and the result in the visual?
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