Showing project progress based on Today's Date in percentage

[kamini]

Hi,

I have the Starting and End Dates of certain tasks, but I need to show the progress of these tasks compared to TODAY in some sort of Bar Chart, if possible or a matrix based on Today's date. 

Is there a way to accomplish this in Power BI?

Thanks a lot for your time.

[kamini]

Thanks so much!

[christinepayton]

Sure, I like to do this in Power Query. You just add a custom column and subtract one from the other and transform to days to get the duration. The function for "today" in PQ is "DateTime.Date(DateTime.LocalNow())". I did a video here on how to visualize progress and duration of tasks in the Microsoft Gantt visual if that's useful, it goes through how to do the subtraction. You could also do it in a matrix, but I like Gantt for things with start and end dates. 

[kamini]

Hi Christine, I didn't communicate correctly in my end. I have a Power BI Report presently as an example shown below. I need to add the Percentage of Progress to this report. I was able to add the % of progress after reviewing some of the DAX statements to do so; however, now I need to show the Progress as a separate CARD or included in this Report as a Progress Bar... 

Instead of Percentage Numbers the right most column, I'm trying to find some sort of coloring or visualization, 

Let me know 

Thanks,

[christinepayton]

Sure, you could just click on the measure or column in the values well and use conditional formatting -> data bars. If you set the highest and lowest value there to what you want them to be (e.g. 100% being highest), it should make a bar in your table that gives you a visual impression of size. 

I like to use a light color shade for conditional formatting bars so that when the number overlaps the bar, it's easy to read on both ends. 

Or if you want it in a separate card, just drop it in a card visual? If the % is on a row-by-row basis already, perhaps setting the summarization for it to "average" would be a good option to give you the average % progress. 

[kamini]

Christine, thanks so much. Well, my Progress calculation is a Column and not a measure,

Progress = divide(datediff([start Date], today(), day), datediff([start date], [Finish Date], day))

I also have the Duration as below but I don't get the Data Bar option under Conditioning,

Duration = DATEDIFF('ITD Projects'[Start date],'ITD Projects'[Finish Date],DAY)

Thanks for your time.

[christinepayton · Accepted solution]

It looks like you need an aggregation selected in the visual for it to show up according to this post (if you don't have one, click on the field in the values well to add one): https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-no-data-bars-option/td-p/31...

I see you have one already for Duration but unsure about the Progress. I'm assuming Progress is some sort of number type column also (it needs to be).