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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.