NKDev
NKDev

Reputation: 474

Power Bi - Change font color of text in Matrix Visual

Is it possible to change font color of text in Matrix Visual based on some condition. I tried conditional formatting in table but it changes the background color of cell.

Thanks

Upvotes: 0

Views: 3849

Answers (2)

questionto42
questionto42

Reputation: 9542

In Power BI Desktop January 2024 and likely in the version before (since the link was changed in 2023), you can choose a conditional formatting for the font color column by column, see Apply conditional formatting in tables and matrixes - Format background or font color - Microsoft Learn. Thus, each column needs its own conditional formatting.

German to English:

  • "Bedingte Formatierung" = "conditional formatting"
  • "Schriftfarbe" = "font colour"

enter image description here

enter image description here

Upvotes: -1

Leonard
Leonard

Reputation: 2578

As of the May 2017 Power BI Desktop release, conditionally changing the font color of a cell in a matrix isn't possible. (You can change the font color of all cells, however.)

I don't have any suggestions for working around this, but if you haven't already, I do recommend voting for this idea in the Power BI Ideas Forum: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering (and perhaps adding a comment to clarify what exactly you'd like to see too, since you might only care about the font color part of the idea for example)

Upvotes: 2

Related Questions