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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Need Help with Guage chart

Hi Everyone, 

I have a very peculiar requirement in guage chart . Refer ti the screenshot below. Target is 95% and achieved is 100%. Here i want two color. I want to show the part of the guage chart from 0 to target line with one colour and rest of the guage chart after target line with another colour. Can any one please tell me how can we achieve this ??

Rajeshkumaryarl_0-1693415964022.png

 

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super User

Hi @Anonymous 

The standard gauge chart lacks this functionality and operates like a 'refillable container.' The color variation becomes apparent only when the level is below the target.

 
 
 

Ritaf1983_0-1693417184797.png

As an alternative you can use anbother free chart from market place - "Tachometr".

Ritaf1983_1-1693417311062.png

This kinf of graph , has ranges options , so you can play with the colors:

Ritaf1983_2-1693417378596.png

For more information tak a look on the linked tutorial:

https://www.youtube.com/watch?v=iXYWlo154Jk


You can also doanload my sample file from: the link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Hi @Anonymous  about the first part, I attached a link.
You can download it and follow my steps.
According to the card, you just need to bring it forward with the format functionality:

Ritaf1983_0-1693420030576.png

I added it to the linked file.

Here is a link again: The link to a sample 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

6 REPLIES 6
Ritaf1983
Super User
Super User

Hi @Anonymous 

The standard gauge chart lacks this functionality and operates like a 'refillable container.' The color variation becomes apparent only when the level is below the target.

 
 
 

Ritaf1983_0-1693417184797.png

As an alternative you can use anbother free chart from market place - "Tachometr".

Ritaf1983_1-1693417311062.png

This kinf of graph , has ranges options , so you can play with the colors:

Ritaf1983_2-1693417378596.png

For more information tak a look on the linked tutorial:

https://www.youtube.com/watch?v=iXYWlo154Jk


You can also doanload my sample file from: the link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

Any luck on this Target Color issue? I am trying to fix it, too! The Actual is accepting color but unable to change color for Target.

Gauge Target.png

 

Anonymous
Not applicable

Hi

Thanks for the inputs. 

But how did you achieve to keep a different colour after the target line ??

This is one of my requirement. I do have another requirement which is as follows. I need to have target to come within the semi circular groove. and dial pointing to the target line. I did create it using a card visual within the space in the semi circular groove. But it is not showing when i click outside of card. 

Rajeshkumaryarl_0-1693418458137.png

 

Hi @Anonymous  about the first part, I attached a link.
You can download it and follow my steps.
According to the card, you just need to bring it forward with the format functionality:

Ritaf1983_0-1693420030576.png

I added it to the linked file.

Here is a link again: The link to a sample 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

Hi @Ritaf1983 , thank you for your inputs. But I did not find any step on how to change the colour after the target line. Could you please help me on this ??

Hi @Anonymous 
Did you download the attached file?

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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