I want to find a way to display the progress of my project?

[jsshugh]

My Dashboard displays many projects, and when you drill down on a project it takes you to a drill down page with many KPIs being shown. I want a visualization that displays whether the project is on track to be finished by its stated deadline. Ideally leveraging the current date and the stated date for its "deadline." I was thinking of a visualization where the colour would gradually turn more "red" as we closed in on the deadline date.

Any suggestions of what the best visualization would be and how to do it? Thank you!

[v-yangliu-msft]

Hi  @jsshugh ,

You might consider using a table to display the gradient of colors

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Count = COUNTX(FILTER(ALL('Table'),'Table'[Project]=EARLIER('Table'[Project])),[current date])

2. Create measure.

progress rate = RANKX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])&&'Table'[current date]<='Table'[stated date]),CALCULATE(MAX([current date])),,ASC)

level =
IF(
    MAX('Table'[current date])<MAX('Table'[stated date]),[progress rate] ,MAX('Table'[Count])+1)

3. Click [current date] – Conditional formatting – Background color.

4. Enter the Background color interface.

Format style – Gradient

What field should we base this on? – [level]

Color choice red

5. Result:

If [current date] < [stated date], there will be a gradient of red, but not true red.

When [current date] >=[stated date]. will be true red

Best Regards,

Liu Yang

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

[amitchandak]

@jsshugh , There are Gantt Chart visuals or you can use matrix visual as I explained in video

Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs

Gantt Chart, project timeline visual
https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380765?tab=Overview
https://www.mpug.com/articles/how-to-create-an-amazing-gantt-chart-in-power-bi/
https://blog.pragmaticworks.com/power-bi-custom-visuals-as-timeline
https://www.youtube.com/watch?v=SO4mk1H94OA
https://xviz.com/visuals/gantt-chart/