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 Se...
Need Help
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