cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Noak Member
Member

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

Capture.PNG

BR,
Noa.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: wrong dates displayy

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.

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
6 REPLIES 6

Re: wrong dates displayy

@Noak

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

HTH,

Frank

Noak Member
Member

Re: wrong dates displayy

Hi @BetterCallFrank

I already did it still same issue

mnm.PNG

BR,
Noa.
Noak Member
Member

Re: wrong dates displayy

Please help me
BR,
Noa.
Highlighted
Community Support Team
Community Support Team

Re: wrong dates displayy

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.

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Noak Member
Member

Re: wrong dates displayy

hi @v-shex-msft

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

ggg.PNG

Q1 -2017 Should be the latest.

BR,
Noa.
Noak Member
Member

Re: wrong dates displayy

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

 

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

 

thank you!.

BR,
Noa.