topic Re: Color change do not apply on setting in DAX Commands and Tips

Color change do not apply on setting

fbittencourt — Tue, 17 Sep 2024 13:27:38 GMT

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:

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

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!!

Re: Color change do not apply on setting

HotChilli — Tue, 17 Sep 2024 13:41:21 GMT

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-by-rules-for-percentages

Re: Color change do not apply on setting

BeaBF — Tue, 17 Sep 2024 13:43:40 GMT

fbittencourt hi! Can you attach the pbix file?

Re: Color change do not apply on setting

fbittencourt — Tue, 17 Sep 2024 15:01:00 GMT

Unfortunately not is sensitive data.tks

Re: Color change do not apply on setting

fbittencourt — Tue, 17 Sep 2024 15:22:16 GMT

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.

Re: Color change do not apply on setting

Anonymous — Wed, 18 Sep 2024 06:15:24 GMT

Hi, fbittencourt

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

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.

Re: Color change do not apply on setting

fbittencourt — Wed, 18 Sep 2024 14:42:11 GMT

Peefect problem solved thank you vey much !!!