Forum Discussion
Solved
Conditional Formatting - Bar Chart with Drilldown
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?
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
2 Replies
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 LinkedInThank you, this worked perfectly
