Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
fbittencourt
Regular Visitor

Color change do not apply on setting

I have a column that display a mesure % using divide function, I have tried to apply on settings the mesure to change the font color.

 I have selected the fields:

fbittencourt_1-1726579334246.png

But the table has a bug and do not apply the change.

fbittencourt_2-1726579414283.png

I have tried also to apply this mesure 

Format cond derive budgetaire = IF(
    [Dérive Budgétaire en %] > 10, "#e66c37","#000000"), even like this using field value doesn´t work.
 
Thanks in advance for your help!!

 

 

1 ACCEPTED SOLUTION
v-zhangtin-msft
Community Support
Community Support

Hi, @fbittencourt 

 

I tried your second method and it is displaying the colors properly.

vzhangtinmsft_1-1726640069419.png

vzhangtinmsft_0-1726640046892.png

Please check out the attachment hope it helps.

 

Best Regards,

Community Support Team _Charlotte

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

View solution in original post

6 REPLIES 6
v-zhangtin-msft
Community Support
Community Support

Hi, @fbittencourt 

 

I tried your second method and it is displaying the colors properly.

vzhangtinmsft_1-1726640069419.png

vzhangtinmsft_0-1726640046892.png

Please check out the attachment hope it helps.

 

Best Regards,

Community Support Team _Charlotte

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

Peefect problem solved thank you vey much !!!

BeaBF
Memorable Member
Memorable Member

@fbittencourt hi! Can you attach the pbix file?

Unfortunately not is sensitive data.tks

HotChilli
Super User
Super User

This is conditional formatting and it looks like a common mistake is being made.

Using 'percent' is not related to the data type of the field involved.

There's specific advice here : https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color... 

Just to bring more information, even though I apply the percentage as 0,20 and 1 ( 20%/100%) the color rules do not apply on whole the table, second the data type of the measure is percentage.

fbittencourt_0-1726586389390.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors