Forum Discussion

GWright87's avatar
GWright87
New Member
4 years ago
Solved

Gauge - Displaying % achieved

Currently on a report I produce I have a number of Gauge charts showing the in month, year to date and forecast performance against plan (all in whole numbers).  I want another gauge which shows as a...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi GWright87,

     

    Fior that you need to add two cards with both values, or a measure that makes the sum.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
4 years ago

Hi GWright87 ,

 

For making this you need to create the percentage metrics in this case the Target gauge would be something similar to the metric below:

 

Target % = DIVIDE( SUM(Table[Actual]), SUM(Table[Target]))

 

This measure would give you the 31%, replace the columns by the ones you use for the Target and for the actual values.

 

If you need any further assistance can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

GWright87's avatar
GWright87
New Member
3 years ago
Thank you Miguel that has sorted my issue. Also how do I create the gap and target visuals below the gauge that i showed on the image i posted?
  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    Hi GWright87,

     

    Fior that you need to add two cards with both values, or a measure that makes the sum.