Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MOM Error getting a straight line

Hi Everyone:smileyhappy:   Can any one help me in achieving the MOM % trend in the below scenario. I am using the trend of 13 months using the below formula.(Creating the what if parameter).   ...
General Comment
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Anonymous,

     

    On the chart select the 3 dots and sort by month in the PBIX file it's sort by value.

     

    Regards,

    MFelix

  • Anonymous's avatar
    Anonymous
    7 years ago

    Got it:)

     

    MFelix, I have found a solution for this by creating a sort column in summary Table.

     

    DAX formula:- 

    YEAR('Summary Table'[EndOfMonht])*100+MONTH('Summary Table'[EndOfMonht])
     
    Thanks,
    Akhil.
     
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi Anonymous,

 

I have found a solution for this problem, however yesterday I have tried to publish my solution and my post was deleted from the forum, don't understand why.

 

I will try to redo the post later.

 

Sorry for taking so long to answer.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi MFelix,

 

Thanks for the solution:smileywink:. Its perfectly working.

 

Could you please to sort the trend, trend is not getting sorted by Month and Year?

 

Regards.

Akhil.

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi Anonymous,

     

    On the chart select the 3 dots and sort by month in the PBIX file it's sort by value.

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi MFelix,

       

      I have tried this by sorting Month and year, but the trend is not sorted.

       

      Attaching the screenshot below. Do you have any other solution for this.

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Got it:)

         

        MFelix, I have found a solution for this by creating a sort column in summary Table.

         

        DAX formula:- 

        YEAR('Summary Table'[EndOfMonht])*100+MONTH('Summary Table'[EndOfMonht])
         
        Thanks,
        Akhil.