Need Help: KPI Reporting

Hi Anonymous,

Based on my test, you could refer to below stesps:

Sample data:

Create a measure to show the KPI:

KPI = IF(MAX('Table1'[Current Cost])<MAX('Table1'[Prev Cost]),UNICHAR(8601),IF(MAX('Table1'[Current Cost])>MAX('Table1'[Prev Cost]),UNICHAR(8599),UNICHAR(8596)))

Result:

Use the conditional formatting function to modify the [Complete] column:

Result:

You could also download the pbix file to have a view.

https://www.dropbox.com/s/su9xsctgtd1tqco/KPI%20Reporting.pbix?dl=0

Regards,

Daniel He

Hi Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He