Multiple stacked column chart

Hey Anonymous ,

you can control the fill color of a column/bar by using conditional formatting.

To change the color of the columns from this:

 to this

I created this measure:

Measure 2 = 
var _category = MAX('Dimension Customer'[Category])
var fillColor = IF(_category = "N/A" , "red" , "#808782")
return
fillColor

What the measure does is this:

It reads the current value of the column Category by using the MAX(...) function. The column is used as inner axis-label.

If the current value equals "N/A" then the color "red" should be used, otherwise a hexcode.

I applied the measure for the conditional formatting by changing the data colors option of the chart:

Hopefully, this provides what you are looking for.

Regards,

Tom