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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi barakb32 ,

 

Your solution sounds really interesting !

Do you have an example showing how it is built on GitHub?

I feel comfortable using ggplot2 or matplotlib but it is different to build an entire visual from scratch...

 

Regards, 

Romain

 

barakb32 wrote:

Hi Mardin ,

 

We had the same requirement.

We used the Python visual to meet this requirement.

 

Regards,

Barak

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks barakb32 , this is really nice !

     

    Best regards,

    Romain

  • 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.