Forum Discussion

Sac's avatar
Sac
Icon for Helper I rankHelper I
9 years ago

Display Quater and Month-year in same graph

I want to show the Quater and Month-Year both in chart . Can i do so ?

I follow the japanese finanicial year So April - April.

 

Want the Output looklike :

 

for example. The Current month is Sep. & Year is 2017.

So

Apr 2016 to Mar 2017 will come in to Quater.

 

Apr 2016   - QTR 1 FY16

May 2016 - QTR 1 FY16

June 2016 - QTR 1 FY16

Jul 2016 - QTR 1 FY16

Aug 2016 - QTR 2 FY16

Sep 2016 - QTR 2 FY16

Oct 2016 - QTR 2 FY16

Nov 2016 - QTR 2 FY16

Dec 2016 - QTR 3 FY16

Jan 2017 -QTR 3 FY16

Feb 2017 - QTR 3 FY16

Mar 2017 - QTR 3 FY16

Apr 2017

May 2017

Jun 2017

Jul 2017

Aug 2017

Sep 2017

 

Final visualisation in  graph would be ( X axis) :

 

QTR 1 FY16  QTR 2 FY16  QTR 3 FY16   QTR 4 FY16  Apr 2017  May 2017   Jun 2017   Jul 2017   Aug 2017    Sep 2017

 

And display Quater and month ( Starting from Apr 2017 ) in chart with sorting.

 

Please help me. It is very important and urgent.

 

Thank you.

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Sac,

     

      As much as I understand from the description of the issue, I can say that you can have a single calculated column in your calendar table that has a structure like Month-Qtr-Year, then you can use it in your visuals.

     

    Regards

     

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Sac,

     

    In source table, create a calculated column first.

    MonthNO =
IF (
    'Test Table'[Date] >= DATE ( 2017, 4, 1 ),
    FORMAT ( 'Test Table'[Date], "MMM YYYY" ),
    "QTR"
        & IF ( 'Test Table'[Date].[QuarterNo] = 1, 4, 'Test Table'[Date].[QuarterNo] - 1 )
        & " "
        & IF (
            'Test Table'[Date] >= DATE ( 2016, 4, 1 )
                && 'Test Table'[Date] < DATE ( 2017, 4, 1 ),
            "FY16",
            "FY17"
        )
)

    In Query Editor mode, add a custom column to return month number, then add a conditional column based on the previous custom column.

    Then, select the calculated column [MonthNO], change its default "Sort by column" to [Sorting] as shown in below image.

     

    Now, you can add [MonthNO] column into X-axis.

     

    Best regards,
    Yuliana Gu

    • Sac's avatar
      Sac
      Icon for Helper I rankHelper I
      9 years ago

      Thank you for solution.

      But i am still gettting problem in sorting even though i follow same step that you menyion.

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi Sac,

         

        Could you describe your problem more detailed? What is current result you get? Please post an image.

         

        Regards,
        Yuliana Gu