Bar chart bar colour conditional formatting

[Fusilier]

Hi,

I have this clustered bar chart:

I have conditional formatting set via a rule : Red for negative values, Green for positive.

Can anybody thing of a method where I can keep this conditional formatting but also have one of the individual bars highlighted in a different colour depending on whether one of A-L is selected in a slicer?. I don't think its possible, but thought I would ask.

[tharunkumarRTK · Accepted solution]

 @Fusilier
You can achieve this by writing a dax measure for your conditional formatting logic 

and then you can choose 'field value' for formatting and then select the measure you created before

I am attaching the pbix file for your reference

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[Fusilier]

Thank you so much! Works like a dream. Didn't think this was even possible!