Conditional Formatting based on Matrix Total (for Personalized Visual)

[garynorcrossmmc]

Hi again,

I am putting together a matrix visual that looks like this:

On the column for 'Total Hiring Rate', the user has requested that this field has conditional formatting applied based on the row's value vs. the column total.  I've seen solutions on this forum where it's suggested to create a measure for conditional formatting based on ALLSELECTED(Row Dimension), however this visual is set up as a personalized visual, where the row dimension will change based on the users' preferences.

How can I apply conditional formatting to this column based on that row's difference from the grand total?

[v-xulin-mstf]

Hi @garynorcrossmmc,

Is your issue solved?

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf]

Hi @garynorcrossmmc,

You can calculate the difference between rows and grand total with a measure.

And then you can apply conditional formatting with the measure.

Best Regards,
Link

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

[Greg_Deckler]

@garynorcrossmmc You can get the grand total by using something like a CALCULATE([Measure],ALL('Table')) or SUMX(ALL('Table'),[Column]). You could then do a ratio between the current value and this value for your conditional formatting.