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!