topic Change column color in a bar chart based on a slicer in DAX Commands and Tips

Change column color in a bar chart based on a slicer

Anonymous — Fri, 03 Jun 2022 13:33:07 GMT

Hello Everyone,

I have a simple table (Name, Value) , and I have a slicer with Name

Requirement:

When I select a name, the bar of this name changes its color, like this picture

My thoughts are:

1. delete the interaction between the slicer and the bar chart

2.develop a dax formula to get only the selected value ( SelectedValue function won't work as it will get a the same name for each row)

3. this dax will generate 1 only for the selected row and 0 for other rows

4.make color code based on the rule that this function = 1 to be red

Thanks

Re: Change column color in a bar chart based on a slicer

amitchandak — Sat, 04 Jun 2022 03:54:49 GMT

Anonymous , Create an independent date table with name

Names = distinct(Table[Name])

then create a color measure and use that in conditional formatting using field value option

You can use color name or hex code with prefix #

color = if(isfiltered(Names[Name]) && Max(Table[Name]) in allselected(Names[Name]) , "Red", "Blue" )

PowerBI Abstract Thesis: How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539

Re: Change column color in a bar chart based on a slicer

Anonymous — Sat, 04 Jun 2022 04:37:16 GMT

Thank you amitchandak this helped alot,

also I developed a calculation with same logic that may help anyone

color 2 = IF(HASonevalue(Names[Name])&&SELECTEDVALUE('Table'[Name]) in VALUES(Names[Name]),"Red","Blue")

Re: Change column color in a bar chart based on a slicer

zona — Mon, 14 Nov 2022 20:57:32 GMT

Similar problem that you've answered before. Want selected column to be a different color. I followed your instructions, but cannot get only one column to change color based on slicer selection. All columns turn blue or red.
What I have:

What I want:

Table

DISTINCT = distinct('Example'[Letters])

Measure

Colors = IF(ISFILTERED(Example[Letters]) &&

Max('DISTINCT'[Letters]) in

ALLSELECTED(Example[Letters]),"Red","Blue")

Please advise what I am doing wrong. Thanks!