Forum Discussion
Exceeded target visual
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!
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,
KellyDid I answer your question? Mark my post as a solution!
4 Replies
I would think the KPI visual?
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.
You can try bullet chart
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380755?tab=Overview
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,
KellyDid I answer your question? Mark my post as a solution!
