Forum Discussion

sawn's avatar
sawn
Frequent Visitor
4 years ago
Solved

Best Chart Type that Displays Over Achievement

Hello,

 

I have the following values, Target = 2000 while Achievement is 5000. Which chart type can I use to visualize this information? One that can indicate the target, achievement as well as the over achievement. Thank you

th
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi sawn 

    Thanks for reaching out to us.

    >>

    1. Radial gauge charts in Power BI - Power BI | Microsoft Docs

    Radial gauge charts in Power BI

    you need to create a measure, 

    Over Achievement = MIN('Table'[Achievement])-MIN('Table'[Target])
    and put it into tooltip

    2.  table visual

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi sawn 

    Thanks for reaching out to us.

    >>

    1. Radial gauge charts in Power BI - Power BI | Microsoft Docs

    Radial gauge charts in Power BI

    you need to create a measure, 

    Over Achievement = MIN('Table'[Achievement])-MIN('Table'[Target])
    and put it into tooltip

    2.  table visual

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.