Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.
@Anonymous , That is strange. Check you do not have any such value in FY Week. Usually, Range end restricting it to available value
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |