Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

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

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.




New Member

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.Capture.JPG

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.


Xi Jin.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.