Visual Help for Last Week vs. Current Week Milestone Dates

[aliawais]

Hi,

I'm trying to develop a Power BI report as per below report that could show Current Vs Last Week Milestones Dates. I have tried several visuals in power BI desktop but still struggling with a solution. Need to know which visual i should use to develop similar kind of report in power bI and how source data should be built up.

I have also attahced sample excel file below for the type of data i have for this report. Could anyone guide me in this regards?

Thanks

[aliawais]

Thanks alot for your response. I'll test these visuals 🙂

[v-angzheng-msft · Accepted solution]

Hi, @aliawais 

I doubt whether the default visual can do it. You can search for possible working visuals in the AppSource.
The following three visuals seem to be close to this topic, and you can test them in your model.

graphomate matrix

Inforiver Professional Matrix / Table

Inforiver Standard Matrix / Table

In a data model where you need to unpivot the current week and last week columns, you can unpivot the columns under the transform tab in Power Query

Your data may look like the following in the end.

Based on the above, you can test whether you can get the desired result.  

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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