Simple KPI

Question

Hello,&nbsp;Everything I can see about KPI's seems to assess trend over time. I just want a simple +/- based on 2 figures:&nbsp;eg.2019 Sales = £1,0002020 Sales = £1,100Indicator = Green upwards arrow, ideally showing +£100 and/or +10%&nbsp;Does this exist?&nbsp;Many tahnks,Mike

mahoneypat · Answer

Yes.&nbsp; You can use conditional formatting and/or icon sets.&nbsp; Please see this post -&nbsp;https://powerbi.tips/2019/07/icons-upon-icons/&nbsp;Also, you can also add icons as text in your measure outputs by holding the Windows key and "." (or ";") and concatenating it with your result.&nbsp; In your case you can use an IF() to have two outcomes each with a different icon.&nbsp;If this works for you, please mark it as the solution.&nbsp; Kudos are appreciated too.&nbsp; Please let me know if not.Regards,Pat

vanessafvg · Answer

have you looked in the custom visualisations?&nbsp; there are quite a few there&nbsp;
&nbsp;
otherwise you can try this
&nbsp;
https://community.powerbi.com/t5/Community-Blog/Power-BI-Desktop-DAX-Using-Unicode-Arrows-as-Measures-in-a-Table/ba-p/190725

amitchandak · Answer

PBIMike , refer if these can help
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

pbimike · Answer

Thanks all, but the conditional formatting fucntion only works when comparing data within a column.&nbsp;I am looking to produce a row such as the example below:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KPI/variance analysisSales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £1,100&nbsp;&nbsp;&nbsp;&nbsp; / &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £1,000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; / &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; +£100/+10% green arrow indicator

v-lionel-msft · Answer

Hi&nbsp;PBIMike&nbsp;,
&nbsp;
What is your original data table?&nbsp;Please give a sample data.
&nbsp;
Best regards,Lionel Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Simple KPI

5 Replies

Related content

Ranking KPI card

KPI Visual - Simple Calculation

KPI level matrix table

New PBI KPI Card?

Simple Sum Filter