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
9 years ago

Mardin,

Currently, in Power BI, it is not possible to use Dates on Y axis as shown in your image, Power BI expect a measurement on Y axis.

As a workaround for your issue, you can create the MTA chart in Excel, then pin the chart to Power BI Dashboard following the guide in this article. Another option is to create the visual using R in Power BI, for more details, please review this similar thread.


Regards,
Lydia

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

    Thanks for the tips! :-)

     

    Do you know if it's possible to incorporate an Excel chart in a PowerBI Report? ...Not pin it to a Dashboard but actually show it within a report. For this task it would not be feasable to only pin it in a Dashboard since the chart is to be used next to other stuff in the report.

     

    I may have to look in to R-script at some point, but at the moment I haven't learned it yet.

     

    Right now I am playing with the thought of simply converting the dates that I need on the Y-axis to some sort of Index number or value representing the date. Any ideas are welcome! :-)

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Mardin,

      There is no method to incorporate Excel chart in Power BI report except pinning the chart to dashboard.

      As your post, you can try to convert dates to numeric data.

      Regards,