Chart to plot due dates for different tasks

[joker449]

I am trying to create a graph that lists milestone dates by project.

My data shows each project in the row, and various due dates:

In Power Query, I then Unpivoted the data so I have a single column for the activities (Key Activity) that need to occur, and their due dates (Key Activity Due Date):

My goal is to plot the projects and show the related activities on a single line, plotted like so (note that the green line would be a reference line to the current date so that progress can be tracked).

I created the 3rd image in Tableau, but am wondering if this is possible in PowerBi? The more I mess with it, the more I think not.

Thanks in advanced!

[Anonymous]

Hi @joker449 ,

Did @DataNinja777  reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

Best Regards,
Adamk Kong

[DataNinja777 · Accepted solution]

Hi @joker449 

Welcome to Power BI 😊  I assure you that you can produce your required output which you created in Tableau using Power BI, too.   For example, using standard matrix visual, a visualization like below is created using your data.  

What I did is to create a measure of today as the reference line, and create a color measure like below and link it with you measure which you want to color as using conditional formatting.  

Today = if(max('Calendar'[Date])=today(),"┃",blank())

I created a calendar column and linked with the unpivoted fact table to enable flexible date analysis.  

The above example is just using the standard matrix visual, and I suppose you can get exactly the same layout like putting the date at the bottom instead of at the top and thicker reference line for today if you use custom visuals specifically created for your requirement.  

I attach the pbix file for the example above. 

Best regards,