Forum Discussion

Noak's avatar
Noak
Helper 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 2016 Q4 2016 Q1 2017 - for all times the data is dynamic so the solution should be permanent.

 

please help

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

6 Replies

  • 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
      Helper 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
      Helper 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!.

  • BetterCallFrank's avatar
    BetterCallFrank
    Resolver IV
    9 years ago

    Noak

    you have to add the year from the date hierarchy to X-axis - this will separate q1/16 from q1/17

    HTH,

    Frank