Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Advocate IV
5 years ago

Conditional Formatting based on Matrix Total (for Personalized Visual)

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?

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    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.

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    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!