Forum Discussion
Bar chart bar colour conditional formatting
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.
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 beforeI 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!
2 Replies
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 beforeI 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!
Thank you so much! Works like a dream. Didn't think this was even possible!
