Forum Discussion

hello789567's avatar
hello789567
Advocate I
8 years ago
Solved

Conditional formatting based on another cell

I have these 3 Matrix and I need to format the Current (Week/Month/Quarter) SAO values(Dark Blue) and AOV MRR(Light Blue) values based on the previous Week/Month/Quarter. Green if Greater and Red if ...
Need Help
Tips and Tricks
  • McCow's avatar
    McCow
    8 years ago

    Hi hello789567

     

    such art of formatting is with second transparent table and manipulating with font and background color possible.

    One of table (top level) must be have table style as "None".
    Look on simple example below:

     

    I hope its help. I left extra uneven matrix edges, that you can better see this trick.

    And of course you must prepare a values of means you need (as separate measures or calculated columns).

     

    Best regs

  • hello789567's avatar
    hello789567
    8 years ago

    Thank you for your response! Its looking like controllable formatting is a feature that's just not in Power Bi. I had to resort to inserting "Text Boxes" with no text and giving it a transparent background. Considering how much conditional formatting is helpful to reporting you would think it would be better.

hello789567's avatar
hello789567
Advocate I
8 years ago

Thank you for your response! Its looking like controllable formatting is a feature that's just not in Power Bi. I had to resort to inserting "Text Boxes" with no text and giving it a transparent background. Considering how much conditional formatting is helpful to reporting you would think it would be better.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi hello789567,

You can create an idea here, and please mark the right/useful reply as answer, so that we can close the thread and more people will benefit from here.

Thanks,
Angelia