Forum Discussion
Missing Page Level Filter Values
Hi Everyone,
I have a date table which corresponds to Microsoft's Fiscal Year (it ranges from FY15 thorugh FY18).
When I use Fiscal Week (a column from said date table) as a Page Filter... I (correctly) see the following:
Note: First six fiscal weeks of FY18 are selected:
18 01 Jul W1
18 01 Jul W2
18 01 Jul W3
18 01 Jul W4
18 02 Aug W1
18 03 Aug W2
But then, there are times... when I use Fiscal Week (a column from said date table) as a Page Filter... and I (incorrectly) see the following... Note: Missing (not seeing) last four weeks of Jun FY17, missing all week of FY18 July and first two weeks of August FY18... see below
Date Filter missing fiscal weeks
Hoping someone can help me understand why this happening and how to fix it.
I never had this problem in FY17, just in FY18.
Thank you!!!
Thanks Felix... the fix seems to be holding throughout the PBIX file... thanks for the guidance. best, Michael
4 Replies
Hi MFelix,
Thanks for your reply! In each tab, I had two page level filters... (1) fiscal week... (2) fiscal year. I cleared the fiscal year filter in each tab (in most cases I had FY15 filtered out)... and then selected all past fiscal weeks (in fiscal week filter... then in fiscal week filter... cleared all weeks that have not as yet happened in FY18.
Although I am going to wait a day or two before saying issue resolved... it appears to have fixed the issue of missing fiscal weeks in page level filter drop down.
To answer your question: I did not notice any missing items in any other page level filter... although it would not have been as easy to notice as dates.
If issue stays resolved I will close with thumbs up in a day or two. Thanks MFelix. :)
