Forum Discussion

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
9 years ago
Solved

wrong dates displayy

Hello, so I'm working on a big report including dates from 2016 and 2017, for some reason the date hirrarchy mix dates from Q1 2016 and 2017. I would like to present 5 Quarter, Q1 2016 Q2 2016 Q3 ...
General Comment
Interesting Links
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Noak,

     

    I agree with BetterCallFrank's solution. Below is a sample about how to use it:

     

    1. Add a calculate column to store the "quarter year".

     

    Year-Quarter = CONCATENATE([Date].[Quarter]," "& [Date].[Year])

     

    2. Drag the new column as the axis field and remove the original date column which in your visual.

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Noak,

 

I agree with BetterCallFrank's solution. Below is a sample about how to use it:

 

1. Add a calculate column to store the "quarter year".

 

Year-Quarter = CONCATENATE([Date].[Quarter]," "& [Date].[Year])

 

2. Drag the new column as the axis field and remove the original date column which in your visual.

 

 

Regards,

Xiaoxin Sheng

  • Noak's avatar
    Noak
    Icon for Helper IV rankHelper IV
    9 years ago

    hi Anonymous

    I alreday figured it on my own , problem is the order as you can see:

    Q1 -2017 Should be the latest.

  • Noak's avatar
    Noak
    Icon for Helper IV rankHelper IV
    9 years ago

    solved i repleased the year with quarter in order to have logic.

     

    Year-Quarter = CONCATENATE( [createdon].[Year]," " & [createdon].[Quarter])

     

    thank you!.