Forum Discussion
Resolver IIIColor bar by *slicer* selection
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
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/10248/2
3 Replies
- amitchandak
Super User
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-numbers-in-the-column
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
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/10248/2
