The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a table, along with a date slicer that the business user can select:
When multiple year's are selected, the fiscal week slicer starts showing weeks that don't exist in the data set. How can I get it to show just the fiscal weeks that are in the dataset?
Thanks so much!
+1 Got the same problem with YearMonth key. 202384 is not a number that exists in the table
Any help on this one, would be much appreciated. Wondering if there's any other ideas.
When I pick dates in the same fiscal year. 202101 to 202120, the visual looks good.
When I pick dates that span multiple years like 202001 to 202120, I get these blank values showing up.
All the data is coming from just one table, and there are no values between 202052 and 202101 in the dataset.
When I use the dropdown, I don't see the extra date values in the slicer, but do in the visual.
It seems like the fiscal year week's go up to 99. E.g. 202099
When I click on the slider, the extra dates do show up in the slider.
Thanks,
Hi, @Anonymous
Not very clear about the structure of your table, the following is a reference may be helpful
https://blog.crossjoin.co.uk/2019/07/10/power-bi-slicers-show-values-that-do-not-exist/
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @amitchandak !
There aren't any values of such. It does seem super strange.
Goes from week 52 of 2019 to week 1 of 2020 for example.
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |