Forum Discussion

Anonymous_'s avatar
Anonymous_
Frequent Visitor
4 months ago
Solved

Filters not working properly

I have a table visual and a date slicer with 3 years -2024, 2025, 2026.    On page 1 - Table, slicer is showing only years 2025 and 2026. But if I copy and paste these visuals to another page, then...
  • grazitti_sapna's avatar
    4 months ago

    Hi Anonymous_ ,

     

    This can not just be filters there are other factors which can impact the visuals, Please do below checks

     

    1.  Check if visual interactions are implacting your visuals (Turn on/off interaction as per requirement)
    2. Turn on show items with no data (Format β†’ Values)
    3. Check hidden filters
      • Visual-level filters on the table
      • Sync slicers
      • Page-level filters
      • Go to View -> selection and check if there's any hidden filter which is getting applied
    4. Relationship/Data model issue -> check your relationships are set up correctly, if you are using dates from separate tables it's adviced to create a separate date table and use dates from that table by creating correct relationships with fact/dimension tables
    5. Bookmarks can be another reason -> check that bookmarks are not messing up the visuals

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    πŸ’‘ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    πŸŽ– As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    πŸ”— Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!