Dynamic Bar Color

[tahechadv_2022]

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?

[dcrosseto · Accepted solution]

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')

return

SWITCH(

     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

https://prnt.sc/1wBO_R8f3UsN

Hope it helps,

Regards,

Douglas.

[tahechadv_2022]

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)?

[tahechadv_2022]

I just solved the problem

var filter_selected = SELECTEDVALUE(cad_processo[Ganho/Perda])

return

SWITCH(

     TRUE(),

     filter_selected = "Economia", "#4180c0",

     filter_selected = "Ganho", "#162c48",

     filter_selected = "", "#162c48",

     "4180c0"

)

[dcrosseto]

Boa!! 😄

You can also use the function ISFILTERED, it returns True or False regarding of the slicer selection.

Abraços,

Douglas.

[tahechadv_2022]

I didn't understand your logic, can you give me an example?