Missing Page Level Filter Values

[mbwt]

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!!! 

[v-chuncz-msft · Accepted solution]

@mbwt,

Glad to hear that. If you have any other question, feel free to post a new message.

[MFelix]

Hi @mbwt,

Do you have any other page filters when you have the so call incorrect? The filters interact with the other ones so.you can be filtering out information without realizing it.

Regards,
MFelix

[mbwt]

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.  🙂

[mbwt · Accepted solution]

Thanks Felix...  the fix seems to be holding throughout the PBIX file...  thanks for the guidance.  best, Michael

[v-chuncz-msft · Accepted solution]

@mbwt,

Glad to hear that. If you have any other question, feel free to post a new message.