Conditional formatting help

[Bjohnson07]

Help: Conditional formatting based on a column and TC Name and a value associated with that TC name on the spreadsheet.

Example table below:

TC Name	Project #	Ave Load (CF applies here)
TC1	0	0%
TC2	25	218%
TC3	7	44%
TC4	16	114%

So I was giving a R/Y/G fill for the percentages in the "Ave Load" column. I used conditional formatting in a regular pivot and used a formula which I based on looking up the TC name and finding the figure associated with each TC for a max/min load.  I used the TC name to look up the value and if it was over the max % listed in the table it codes it Red, if it was between the max & min % it is green and anything under the min % is yellow. Worked great.

the lookup formula in the regular pivot:

=vlookup(TC Name,*ARRAY*,Max load (or min load),false)

Moving everything to Power BI I cannot figure out how to do the same and I would like the same table in my reports. You cannot enter a formula in the conditional formatting (at least not that I can figure out) I hope I am explaining this well enough so you fine folks can probably tell me I'm over complicating it and help point me in the right direction. Any help is appreciated. Thanks

[v-cherch-msft]

Hi @Bjohnson07

It seems you may create measures with IF condition and use it for conditional formatting like this post. If you need further help, please provide more details about the max/min or share the .pbix file for us. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

[v-cherch-msft]

Hi @Bjohnson07

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,

Cherie

[parry2k]

@Bjohnson07 you can surely achieve it, do you have ranges for each tc name to show case how it will work?