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
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?
Many thanks,
Andreas
Hi, @Stoppelaar
You can try the following methods.
Column:
Weeknum = WEEKNUM([Date],2)
Period = YEAR([Date])*100+[Weeknum]
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!
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
84 | |
76 | |
64 |
User | Count |
---|---|
145 | |
109 | |
109 | |
102 | |
96 |