Cross-highlight does not work on Conditionally formatted bar chart

[Julia1234]

Hi, I came accross an issue when Bar chart has conditional formatting on Red-Negative/Green-positive values. But when relevant item on another visuel (based on the same data) is clicked on, the cross highligting does not get conditional formatting applied and negative values remain green.

The desired outcome is that the cross highlighted bar in the bar chart would be colour coded according to the rule on Red-Negative/Green-positive values.

Is there any workaround or dax can be consructed? Like if a certain group is selected, then measure could calculate average in that context, and the conditional formatting will be based on that measure? Thank you in advance!

pbix sample:

https://drive.google.com/file/d/1guru700ytIFLmIbU2ZTHFqU3z7r2RN2d/view?usp=sharing 

Data:

Report:

Cross-highlighted SO8998 but negative bar remains green

[v-xiaotang · Accepted solution]

Hi @Julia1234 

Update -->We received a response from the product team: The current behavior in data colors is by design (conditional format using the value instead of the highlighted value).

However, they are evaluating the possibility to add support for it cartesian charts in the future.

ICM(332165207)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @Julia1234 

Thanks for reaching out to us.

I found that the same measure works in the table visual, but not in the cluster column chart. I will escalate the issue to the product team and I will notify you if there is a response.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Julia1234]

Hi @v-xiaotang 

Yes, it appears to be known issue and below is the post from 2020. It would be great to get it resolved in future releases. In the meantime I wonder if any workaround can be done using DAX measure?

https://community.powerbi.com/t5/Desktop/Conditional-formatting-not-working-correctly-when-cross/td-...

Thank you.