Forum Discussion

PBI12345's avatar
PBI12345
Icon for Helper I rankHelper I
1 year ago
Solved

What filter is being applied to this table?

Hi,

 

Has anybody seen something similar to this before?

 

I've downloaded an old report (built ~1 year ago) from the PBI server and am encountering something unusual. 

 

TABLE 2 has a filter applied to the "Week End Date" field (indicated with grey shading) but is showing as (All) and, when clicked into, doesn't actually show any filtering? Although it's clear that some filter has been applied to filter just on 22/02 date, when looking comparing to TABLE 1.

 

This report currently refreshes weekly on the PBI server and to my knowledge has not had any date parameters applied to it.

 

Any ideas? 

 

 

 

  • Hey PBI12345 ,

     

    Look for slicers that are not visible, by enabling the selection pane via the view menu.
    What filters are listed if you hover over the filter symbol, does the dialog provide any additional hints?

    Hopefully, this provides some ideas?

    Regards,

    Tom

2 Replies

  • Hey PBI12345 ,

     

    Look for slicers that are not visible, by enabling the selection pane via the view menu.
    What filters are listed if you hover over the filter symbol, does the dialog provide any additional hints?

    Hopefully, this provides some ideas?

    Regards,

    Tom

    • PBI12345's avatar
      PBI12345
      Icon for Helper I rankHelper I

      Thanks Tom, the selection pane yielded no futher info however the filter icon as you suggested did show the field that was filtering ! Very odd but thanks for helping me find it.