Forum Discussion

Hannah13's avatar
Hannah13
Regular Visitor
6 years ago
Solved

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 clearl...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    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!
     

     

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I would think the KPI visual?

  • Hannah13's avatar
    Hannah13
    Regular Visitor
    6 years ago

    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.