Forum Discussion
Helper IIMaking shadowed stacked column chart with slicers
Hi GrimReaperX ,
You can apply different colors on the chart based on your condition, for example in my sample, I modify the color formula like this:
Measure = IF ( MAX ( 'Table'[Column1] ) >= MAX ( 'Table 2'[Column1] ), "Grey", IF ( MAX ( 'Table'[Column1] ) >= MAX ( 'Table 2'[Column1] ) - 5, "Orange", "Blue" ) )Get the result. But in the slicer, the text can't be hided, it's by design.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIHi v-yanjiang-msft ,
Thanks for your answer, i greatly appreciate that. Is it also possible to apply different colors on the chart based on different buckets? As you can see from the picture that i shared in first post, there is different colors for specific range.
Moreover, is it possible to hide section below in the slicer? I just want to have slicer itself without any text.
Thank you very much.
Community SupportHi GrimReaperX ,
You can apply different colors on the chart based on your condition, for example in my sample, I modify the color formula like this:
Measure =
IF (
MAX ( 'Table'[Column1] ) >= MAX ( 'Table 2'[Column1] ),
"Grey",
IF (
MAX ( 'Table'[Column1] )
>= MAX ( 'Table 2'[Column1] ) - 5,
"Orange",
"Blue"
)
)
Get the result. But in the slicer, the text can't be hided, it's by design.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.