Changing Font Colors with Equations

[lailailaieric]

Would PowerBI be able to change the font colors on the words based on the calculations in the table?

ie. < 5 is red, 5 to 10 is blue, 15+ is orange. 

Whether a formula or measure would be magnificent. 

Looking forward to hear from you all. 

[Phil_Seamark]

Hi @lailailaieric,

You can change the colour of the bars and columns in some charts but not fonts as yet as far as I know.

Feel free to raise it as an idea and get people to vote for it. 🙂

[lailailaieric]

Dear @Phil_Seamark

I am aware that the bars and columns can change color, but can it be done with a formula and if so what will it be? 

[Phil_Seamark]

I'm pretty sure you can't with font colours yet.  

[lailailaieric]

Sweet!! 

Thanks a lot @Phil_Seamark

Do you have the link or the teaching guide to changing the colors of the columns with formula?

Thanks (: 

[Phil_Seamark · Accepted solution]

I think the feature you are after is called Conditional Formatting which you can apply to matrix and grid

There is more detail here

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/

[lailailaieric]

Thanks so much @Phil_Seamark!! Let me check it out.