Forum Discussion

PBIMike's avatar
PBIMike
Helper III
6 years ago

Simple KPI

Hello,   Everything I can see about KPI's seems to assess trend over time. I just want a simple +/- based on 2 figures:   eg. 2019 Sales = £1,000 2020 Sales = £1,100 Indicator = Green upwards ...
Need Help
PBIMike's avatar
PBIMike
Helper III
6 years ago

Thanks all, but the conditional formatting fucntion only works when comparing data within a column.

 

I am looking to produce a row such as the example below:

                       2020                  2019                                  KPI/variance analysis

Sales              £1,100     /        £1,000          /       +£100/+10% green arrow indicator

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi PBIMike ,

 

What is your original data table? Please give a sample data.

 

Best regards,
Lionel Chen

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