Forum Discussion
Dynamic Bar Color
Hi tahechadv_2022 ,
You can use the SELECTEDVALUE function pointing to the filter and then based on the result, you choose a color, something like this
var filter_selected = SELECTEDVALUE('column used on the slicer')
returnSWITCH(
TRUE(),
filter_selected = "Economia", "Red",
filter_selected = "Ganho", "Gray",
"#FFFFFF" -- you can also use hex code
)
After creating this measure, you apply a Field Value to the colors, on the path below
Hope it helps,
Regards,
Douglas.
Thank-you!
It worked out, for "Economia" and "Ganho"... but
When I click over "Selecionar tudo" (Select all, in english) it returns two colors different colors:
How can I set a specific colors to "Selecionar tudo" (Select all, in english)?
I just solved the problem
Boa!! 😄
You can also use the function ISFILTERED, it returns True or False regarding of the slicer selection.
Abraços,
Douglas.
I didn't understand your logic, can you give me an example?