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,

 

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.