Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
michellepace
Resolver III
Resolver III

Color 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.

1.png

 

As always, thank you.
Michelle

 

1 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...

View solution in original post

3 REPLIES 3
amitchandak
Super User
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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

 

1.png

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...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.