How can we create a gauge chart with dates by milestone.

[jhab953]

Requesting help in creating Gauge chart with Dates in powerBI by Milestone. I'm enclosing the dummy dataset for your reference. Kindly help. 

Client ID, Client Name, Milestone, Start Date, Budged Date, Actual Date

2902435	ABC Ltd.	Scope	01-01-2023	04-20-2023	02/28/2023
2902435	ABC Ltd.	Fieldwork	01-01-2023	05-20-2023	02/20/2023
2902435	ABC Ltd.	Draft report	01-01-2023	06-01-2023	02/23/2023
2902435	ABC Ltd.	Final Report	01-01-2023	08-22-2023	02/20/2023
2902439	XYZ Ltd.	Scope	01-01-2023	02-20-2023	02/19/2023
2902439	XYZ Ltd.	Fieldwork	01-01-2023	03-01-2023	02/20/2023
2902439	XYZ Ltd.	Draft report	01-01-2023	02-23-2023	02/20/2023
2902439	XYZ Ltd.	Final Report	01-01-2023	02-27-2023	02/23/2023

[v-tangjie-msft]

Hi @jhab953 ,

In the power bi desktop, the built-in gauge chart(radial gauge chart) doesn’t have a feature to show the multiple targets. You can vote here.

Multiple targets on gauge 

Instead of that, you can use the Advanced gauge chart or dial chart, you can download it from the Custom visual App source in power bi desktop.

Or you can create a visual by yourself.

Tutorial: Develop a Power BI circle card visual 

Please refer to the following documents for more information.

Create a gauge chart with dates (start. end, today... - Microsoft Power BI Community

Power bi gauge chart - How to use with examples - EnjoySharePoint

Best Regards,

Neeko Tang

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