Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Hope it helps,
Regards,
Douglas.
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |