Forum Discussion
Microsoft EmployeeData missing from Filter Pane but showing in Table
I'm leveraging the same field as a column in a table & a visual-level filter, yet not getting any values in the Filter. Selecting different months yields different values to show in Filter pane, although should be same across the board.
When I select the FY2020-P12 fiscal month I get 4 values:
Some months I get 0 values to return in Filter, some months I get 2-4. I don't think this is a relationship issue, but rather an unknown error - only reason I say this is because I saw the inverse (in filter but not table) on another post that was a confirmed unknown error. However, I wouldn't say I'm an expert in PBI.
Thanks for your help in advance.
Hi v-trkimm ,
Did you set any other level filter, sync slicer or RLS in the related report page? Whether change the visual interactions? Could you please some sample data which applied on table visual and slicers and Fields setting of related visuals? Thank you.
Best Regards
Rena
2 Replies
Hi v-trkimm ,
Did you set any other level filter, sync slicer or RLS in the related report page? Whether change the visual interactions? Could you please some sample data which applied on table visual and slicers and Fields setting of related visuals? Thank you.
Best Regards
Rena
v-trkimmHi Anonymous
Thanks for your comment - I went to Edit Interactions and removed a filter interaction between Fiscal Month & Delivery Domain (the field that was having issues) and it corrected it. I didn't have this issue before this month, so I'm assuming maybe the change in Fiscal Year or addition of new Delivery Domains may have caused it. Nonetheless, it's working now.
Thank you for your help!