I am trying to represent Achieved+deficit and target in gauge chart? or suggest any chart

[ayushg]

Hi All,

Thanks in advance.

I would like to show three meausres in gauge chart mainly:- achieved,target and deficit.

I want to show target as max and achieved and deficit should sum up in different colors to reach to the target.

Would be great if someone will help me on this.

Thanks 

!!!!!

[ayushg]

Hi All,

Thanks in advance.

I am new to Power Bi so please help me suggesting ways of creating gauge chart where I can show Achieved sales, Target Sales as target and if deficit then deficti in different color.

So my idea is to show achieved in yellow followed by deficit in red reaching to target line.

I am able to plot achieved and target line but I am unable to color the deficit region which is blank in below image.

Please help me out.

[v-xjiin-msft]

Hi @ayushg,

As I know, in current Power BI desktop. It is impossible to change the color between value and target values in gauge chart. So I think you can submit an Idea here to make a feature request.

Thanks,
Xi Jin.