Color bar by *slicer* selection

[michellepace]

Hi there. Could someone please help me with the DAX measure to successfully apply conditional formatting such that w25 is highlighted yellow? Sample .pbix and excel files here

I tried to apply @TomMartens  solution but without success. If possible I would *much prefer* not to create any new tables.

As always, thank you.
Michelle

[amitchandak]

@michellepace , Please find the file after the signature. I Added a color measure and used that in conditional formatting of data color .

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[michellepace]

Thank you @amitchandak but I think perhaps you forgot to include the solution. When I select any week, W25 remains green. Could you please re-attach?

[michellepace · Accepted solution]

Hi there, should anyone else be looking for this solution - - I received the answer on Enterprise DNA's forum here: https://forum.enterprisedna.co/t/color-bar-chart-by-slicer-selection-dax-conditional-formatting/1024...