Forum Discussion
Helper IIDynamic Bar Color
Hi guys!
In the following chart, it shows a graph and two filters. "Previsão de Êxito" and "Tipo de Conquista"
I want to change the color of the bars in the chart according to the "Tipo de Conquista" filter.
Example:
When I click over "Economia" it would change to RED, and if I click over "Ganho" it would change to GRAY. (or any other column)
(All bars should change its colors to a single color)
*The Y-axis ("Economia" and "Ganho") are measures
Is it possible?
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.
5 Replies
dcrossetoResolver II
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.
tahechadv_2022Thank-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)?
- tahechadv_2022
I just solved the problem
var filter_selected = SELECTEDVALUE(cad_processo[Ganho/Perda])returnSWITCH(TRUE(),filter_selected = "Economia", "#4180c0",filter_selected = "Ganho", "#162c48",filter_selected = "", "#162c48","4180c0")