Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi, I have a year-week column as whole number when I use it as a filter I got values more then 52 it is something i can do to make those values only show correct values?
Thanks for helping.
@Anonymous ,
i think you want only 52 week in slicer right but can you know me what is your start week and End week show in filter. i hope you getting my point.THANK YOU!!
Hi my start date is 202201 and end date is 202352
@Anonymous Can you explain what you want as a ENDOUTPUT.
Because you have Two years data so its display Two year week so you can add other slicer for year when select year Week Slicer show only selected year week.
@Anonymous Thank you!!
as you can see in my first shot, I my year-week column is whole number and when i use as between filter i got value from 202254 to 202299 and its not right.