Conditional Formatting - Bar Chart with Drilldown

[ymilne]

I'm trying to apply conditional formatting to a bar chart which has drilldown.

The first level is Products, and the scond level is month for full year.  I want the bar chart to be coloured green when viewed at a product level, and for monthly the actuals blue, and the forecast green.

The DAX i'm using is as follows.

Month Colour (FYF) = 

SWITCH ( TRUE(),

SELECTEDVALUE ( Dim_Table_Date[EndOfMonth]) < [CM Date +1] , "#155199", --Blue Colour--

SELECTEDVALUE ( Dim_Table_Date[EndOfMonth]) > [CM Date] , "#44B388", --Green Colour--

"#44B388" )

This works for the monthly data, however, when at Product level it is defaulting to blue and not the green I want.

Is it possible to get the green colour without changing my theme settings?

[Kedar_Pande · Accepted solution]

Updated DAX Measure:

Month Colour (FYF) = 
SWITCH(
TRUE(),
ISINSCOPE(Dim_Table_Product[Product]), 
"#44B388", -- Green Colour for Product Level
SELECTEDVALUE(Dim_Table_Date[EndOfMonth]) < [CM Date + 1], 
"#155199", -- Blue Colour for Monthly Data
SELECTEDVALUE(Dim_Table_Date[EndOfMonth]) > [CM Date], 
"#44B388", -- Green Colour for Monthly Actuals
"#44B388" -- Default to Green Colour
)

If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn

[ymilne]

Thank you, this worked perfectly