Forum Discussion

Mardin's avatar
Mardin
Icon for Advocate IV rankAdvocate IV
9 years ago

Create Milestone Trend Analysis (MTA) in Power BI?

Hi there! I am struggling with a request from a customer who wants a Milestone Trend Analysis (MTA) in Power BI. The main issue is that I need to have Dates as both X and Y axis! Any suggestions? ...
Need Help
adarshthouti141's avatar
adarshthouti141
Frequent Visitor
2 years ago

Hello barakb32 

I have found your PowerBI file with trend analysis. You invoked separate rows with 'BI', '45 Line', and the dates to plot the data points. 


But I have a data not of your kind where the 'Sample Date' is in different column which is 'Data Date' and I have activity 'Finish Date' . 

Could you please tell me how I can plot the 'Data Date' in x-axis and 
the 'Finish Date' with respect to the 'Activity ID' in y-axis? 


 

I have tried to modify the python code and implement with respect to my requirement, but that isn't working.