Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Noak
Helper IV
Helper IV

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
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
v-shex-msft
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

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

 

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

 

thank you!.

BR,
Noa.

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.
BetterCallFrank
Resolver IV
Resolver IV

@Noak

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

HTH,

Frank

Please help me
BR,
Noa.

Hi @BetterCallFrank

I already did it still same issue

mnm.PNG

BR,
Noa.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.