cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## conditional formatting

Hi

I have the below table, the number of students is a count of the students ID and the % of total is the students ID but as a percentage of the row total. I want to format the background colour but just for the % of total column which are RED. I want to coulor the background Red if it is over 10%, Amber if it is 3-9% and Green if under 3%. Is there a way to do this?, thanks for any help

1 ACCEPTED SOLUTION
Community Support

Hi, @WJ876400

According to your description and sample picture, you want to set the conditional format for the [% of Total] for the color Red, right?

You can try my steps:

This is the test data I created according to your sample picture:

1. Create these measures:
``````Number of students =

COUNTX(FILTER(ALLSELECTED('Table'),[ID]=MAX('Table'[ID])),[ID])``````
``````% of Total =

var _total=COUNTX(ALL('Table'),[ID])

return

DIVIDE([Number of students],_total )``````
``````Color format =

SWITCH(

TRUE(),

[% of Total]>0.1,"Red",

[% of Total]<=0.1&&[% of Total]>=0.03,"Orange",

[% of Total]<0.03,"Green"

)``````
1. I created a Matrix and place these columns and measures, then open the conditional format like this:

And you can get what you want, like this:

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

Best Regards,

Community Support Team _Robert Qin

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

Community Support

Hi, @WJ876400

According to your description and sample picture, you want to set the conditional format for the [% of Total] for the color Red, right?

You can try my steps:

This is the test data I created according to your sample picture:

1. Create these measures:
``````Number of students =

COUNTX(FILTER(ALLSELECTED('Table'),[ID]=MAX('Table'[ID])),[ID])``````
``````% of Total =

var _total=COUNTX(ALL('Table'),[ID])

return

DIVIDE([Number of students],_total )``````
``````Color format =

SWITCH(

TRUE(),

[% of Total]>0.1,"Red",

[% of Total]<=0.1&&[% of Total]>=0.03,"Orange",

[% of Total]<0.03,"Green"

)``````
1. I created a Matrix and place these columns and measures, then open the conditional format like this:

And you can get what you want, like this:

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

Best Regards,

Community Support Team _Robert Qin

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.