Color coded based on conditions

[MK3010]

Hi @amruthdna2018

Could you please help to provide sample file with expected output.

I think we have similar solution in another post. Please help to look for this it might help you to achieve your result.

How to do Conditional Format referring to group average Part II

Hi team, I have added Net result in my report. What I would like to highlight was Cost Centre with the Net Result worse than group average not the group total. In my case, Cost Centre 1002,1008,1004,1005, and 1003 should be highlighted. But with the total, it is only highlighted for 1003. Can you please guide me the correct DAX. Many thanks. Regards.ConditionalFormattingBasedOnSubtotal.xlsx (49.4 KB) Q_AverageNetResultbyGroupForConditionalFormating.pbix (50.3 KB)