Forum Discussion

mbwt's avatar
mbwt
Helper I
9 years ago
Solved

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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    mbwt,

     

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

  • mbwt's avatar
    mbwt
    8 years ago

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

MFelix's avatar
MFelix
Super User
9 years ago
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's avatar
mbwt
Helper I
9 years ago

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.  :)

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    9 years ago

    mbwt,

     

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

  • mbwt's avatar
    mbwt
    Helper I
    8 years ago

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