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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Stoppelaar
Frequent Visitor

Period Slicer showing numbers not existing, any solution?

Hi,

I am using a Period slicer on Year & Week, the user can write the year and week and get the data he/she needs but I would like to have the scroll bar, so it's even easier but I have not found a solution where the scroll goes from 202201 to 202252, it keeps going to 202299 and that data does not exist in my table...

 

Is there a solution on this or is it just to accept or take a another option?

 

Stoppelaar_0-1684160101626.png

 

Many thanks,

Andreas

 

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @Stoppelaar 

 

You can try the following methods.

Column:

Weeknum = WEEKNUM([Date],2)
Period = YEAR([Date])*100+[Weeknum]

vzhangti_0-1684293068340.pngvzhangti_1-1684293097394.png

Is this the result you expect? If not, please provide more information.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-zhangti  for your answers! 

 

I have tested it but with the same result! 

So if you are only looking on 1 year then there are no problem, it's when you move from one year to the next you get weeks not existing in the data from week 52(53) to 99!

Stoppelaar_0-1684327357557.png

 

It might be that there are no solution but it's a bit strange that it makes up numbers that is not in the acctual table?

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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