Conditional Formatting on a bar chart. Not working when a filter from another visual is applied

[MelissaL-ERGT]

Hello,

I am after some help please on conditional formatting.

My data set is for a team assessment score. It is a % and is made up on 6 different attributes.

The chart i am trying to conditional format is a bar chart showing the average score for each attribute.

I have set have the conditional formatting as per the screen snip (based on number not %).

I have a table which has all the team names and their overall score, date of last assessment and their survey status.

When i click on a team (using the table as a filter) i like that the Bar chart holds the overall average score for each attribute but then highlights that teams score. However it seems to hold the conditional formatting of the overall average score and not change to the teams score (see below the circled attribute scores should be red)? Is it because of the other values in the table or do i need to change my dax formula? which is 

Average attribute Score (excl blanks) = CALCULATE(AVERAGE(fact_adapt_team_assessment[category_avg_score])/100)

Looking for any suggestions please and thank you

[danextian · Accepted solution]

Hi @MelissaL-ERGT ,

It appears that the behaviour of conditional formatting in cross-highlights is by design which, for me, doesn't make sense. https://community.fabric.microsoft.com/t5/Desktop/Cross-highlight-does-not-work-on-Conditionally-for... 

[Anonymous · Accepted solution]

Hi @MelissaL-ERGT ,

Agree with danextian, you can't achieve this by highlight even change your DAX.

Highlight is different from filter and slicer, its role is only to make the whole report all the data related to the content you clicked to highlight, and other data not related to it is not filtered out but just fade out the display, so in this case you set the Conditional format corresponding to the data is still all the data instead of the In this case, the data in the Conditional format you set is still all the data, not just the FTA Team data.

I suggest you add a slicer or use the filter that comes with the report instead of clicking on a name in the table to highlight it as the filter.

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

[danextian · Accepted solution]

Hi @MelissaL-ERGT ,

It appears that the behaviour of conditional formatting in cross-highlights is by design which, for me, doesn't make sense. https://community.fabric.microsoft.com/t5/Desktop/Cross-highlight-does-not-work-on-Conditionally-for...