Exceeded target visual

[Hannah13]

Hi

I'm looking for help on the best way to show a KPI where the target has been exceeded. For example, target was 1 million but actual was 3.5 million. I tried using a gauge but it doesn't clearly show how in excess of the target the actual is.

Anyone have any good ways to show something like this?

Thanks!

[v-kelly-msft · Accepted solution]

Hi @Hannah13 ,

How about "Data Bar KPI"?Such as below:

You can use a measure to show the gap（I marked in yellow circle）:

Measure = SELECTEDVALUE('Table'[Consumption])-SELECTEDVALUE('Table'[Column1])

You can also convert the gap to an absolute value using below measure:

Measure = ABS(SELECTEDVALUE('Table'[Column1])-SELECTEDVALUE('Table'[Consumption]))

Here is a sample .pbix you can refer to.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

You can try bullet chart

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview

[Greg_Deckler]

I would think the KPI visual?

[Hannah13]

Thanks for your reply. I can't quite get this to work. I think it's because I only have the one set of figures rather than varying figures over a time period. It's literally a year end amount and a target. Thanks.