Background color logic in a single table

[mpraka]

Hi All,

I would like to achieve the below scenario of BG Colors and Font color. Please help me to achieve this.

I have a numeric value, Percentage values and some text values in a single column called "Values".

for e.g., 98, 78% and No Data

My Dataset:

I created a Matrix table as per my requirement:

Now i want to apply the BG color logic to it.

If it falls in Green logic threshold then the bg color should be green. Similar logics for Yellow and Red if it falls in its respective criteria.

If it doesn't have any logics for e.g., NA then that need to be displayed as Grey bg color
Provided my expected color output below:

Please let me know how to achieve this when we have numeric values as well as percentage values in single column and how to bring that in a single table. The problem here is we have 2 data types in single column. and another problem is we have different color logics for different subjects. for e.g., even though science and English having same data type (Integer) the threshold limit for English and Science is different for green, yellow and red.

please help me to achieve this scenario

Thank you in Advance

Regards,

Prakash

[MFelix]

Hi @mpraka ,

Taking into account that you the red and Green is above or lower than you Yellow limits you need to add two columns for additional calculations.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.