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.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 294 members 3,571 guests
Please welcome our newest community members: