Forum Discussion
Noak
Helper IV
Helper IVwrong 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 ...
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
BetterCallFrank
Resolver IV
Resolver IVyou have to add the year from the date hierarchy to X-axis - this will separate q1/16 from q1/17
HTH,
Frank
NoakHelper IV
Helper IVPlease help me