Conditional Formatting to Targets

[condolar]

Hi all,

Trying to create a KPI table visual, with conditional formatting based on a target, which I have put in the column next to it for reference:

However as you can see, the values on the left are below the targets in most cases but showing up as green. This is my current set up:

I can't put in a set value as the targets change accoring to the period selected at any one time, so I felt percentage was the correct count to use, I just can't get it to correspond with the target.

Thanks in advance!

[Anonymous]

Hi @condolar,

I'd like to youngest you switch out format by on expression mode and write a measure expression to check value and return color code to apply formatting conditions.

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

If you are confused about the coding formula, please share some more detailed information to help us glorify your scenario.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[condolar]

https://vimeo.com/744951197 

Hi @Anonymous 

Please see video attatched. As you can see the targets adjust according to the date range selected. I require the conditional formatting to reflect based on the targets shown. This must change with the date range selected as well.

Thank you,

Connor