Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
v-trkimm
Microsoft Employee
Microsoft Employee

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

v-trkimm_0-1597090467281.png

 

When I select the FY2020-P12 fiscal month I get 4 values:

v-trkimm_1-1597090761269.png

 

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. 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.