Forum Discussion

kala2's avatar
kala2
Helper III
4 years ago
Solved

Milestone Trend Analysis Using Python

Following the example of the implementation on the github repo: https://github.com/barakb32/PBI-MTA And the topics: https://community.powerbi.com/t5/Desktop/Create-Milestone-Trend-Analysis-MTA-i...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi kala2 

    It seems that the problem is in your python statement, under the for column in pivot.

    Because some rows with NaT, so you should try to remove the null rows.

    I'm not particularly skilled in python either. Maybe this code replace it.

    plt.plot_date(clean['45 Line'].dropna(axis=0).index,clean[column].dropna(axis=0).values,xdate=True,ydate=True,ls='-', lw=1)

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi kala2 

It seems that the problem is in your python statement, under the for column in pivot.

Because some rows with NaT, so you should try to remove the null rows.

I'm not particularly skilled in python either. Maybe this code replace it.

plt.plot_date(clean['45 Line'].dropna(axis=0).index,clean[column].dropna(axis=0).values,xdate=True,ydate=True,ls='-', lw=1)

 

Best Regards

Community Support Team _ chenwu zhu

 

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