Guage 3 measures

[AndyTrezise]

Hi All

Is there a visual that can measure 3 values?

For example:

Target Value

Forecasted Value

Actual Value

I want to display how how close someone is to meeting their target based on the actual values they have submitted but also need to show what their forecasted (or projected) target is which is built from another measure.

Not sure if the standard guage can do that?

And also - I would need clear visible labels rather than just numbers so that people understood what each number represented.

Any help would be much appreciated.

Thanks

[dkay84_PowerBI · Accepted solution]

Try the bullet chart:

https://app.powerbi.com/visuals/show/BulletChartBySQLBI1444839436922

[AndyTrezise]

Thanks - think that should do the job.

However is there anywhere to customise or add labels? I only appear to see a value for one of the categories - the progress bar and target for example have no lables so unless you understand the data source there is no way of knowing what the numbers mean. 

[dkay84_PowerBI]

I haven't used this visual personally but perhaps ask this as its own question here in the forums.  I'm sure someone has figured out how to do what you are hoping to do (or a workaround)