Forum Discussion

abhargava's avatar
abhargava
Frequent Visitor
1 year ago
Solved

Slicer Retains Old Values Even After Data Source Updates (DirectQuery)

I'm facing an issue with slicers in my Power BI report that uses DirectQuery. I have a slicer based on a column containing project names from my SQL database. Whenever a new project is added to the d...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago
    Hi abhargava  ,
    Thanks for reaching out to the Microsoft fabric community forum.
     
    The issue you're encountering with slicers retaining outdated project names in Power BI while using DirectQuery is likely due to how Power BI caches data for slicers and visuals, this might be why the slicer is retaining old project names in Power BI while using DirectQuery. Here's the steps and suggestions to ensure that your slicer always shows you the current project names : 
     
    Solution 1: Clear Slicer Cache Automatically. Power BI slicers may retain cached values. To clear this:
     
        1.Use a Reset Button:
                • Add a button in your report for clearing slicer selections.
                • Go to the View tab, enable Bookmarks and Selection Pane.
                • Create a bookmark where slicers are cleared:
                        • Set slicers to their "default" state.
                        • In the Bookmarks Pane, click Add, rename it (e.g., "Reset Slicer"), and ensure the Data 
                           option is checked.
                • Link the bookmark to the button.
      2.Reset Slicers on Page Load (Bookmark Method):
             • If slicer values must reset automatically when a user navigates to the page:
                        • Use the bookmark as the default state for the report page.
                        • Set the page to load with this bookmark applied.
     
    Solution 2: Force DirectQuery Refresh. DirectQuery mode fetches data dynamically, but cached slicer data can                    still persist. Ensure your visuals are refreshing correctly:
     
        1.Enable Auto-Refresh for Visuals:
                • Go to File > Options and Settings > Options > Data Load.
                • Under DirectQuery, check Allow data previews to refresh.
         2.Use the "Refresh Now" Button:
                • Add a "Refresh Now" button in Power BI to force all visuals (including slicers) to refresh when  
                      clicked.
         3.Disable Data Caching for Slicers:
                • In slicer settings:
                           • Go to the slicer's Format pane > Data/Items and set it to dynamically refresh by 
                              ensuring no static filters are applied.
     

    If this post helps, then please consider Accept it as the solution and give a Kudos to help the other members find it more quickly. If you have any other queries you can reach out to community forum for assistance.

    Thank you. 

     
Anonymous's avatar
Anonymous
Not applicable
1 year ago
Hi abhargava  ,
Thanks for reaching out to the Microsoft fabric community forum.
 
The issue you're encountering with slicers retaining outdated project names in Power BI while using DirectQuery is likely due to how Power BI caches data for slicers and visuals, this might be why the slicer is retaining old project names in Power BI while using DirectQuery. Here's the steps and suggestions to ensure that your slicer always shows you the current project names : 
 
Solution 1: Clear Slicer Cache Automatically. Power BI slicers may retain cached values. To clear this:
 
    1.Use a Reset Button:
            • Add a button in your report for clearing slicer selections.
            • Go to the View tab, enable Bookmarks and Selection Pane.
            • Create a bookmark where slicers are cleared:
                    • Set slicers to their "default" state.
                    • In the Bookmarks Pane, click Add, rename it (e.g., "Reset Slicer"), and ensure the Data 
                       option is checked.
            • Link the bookmark to the button.
  2.Reset Slicers on Page Load (Bookmark Method):
         • If slicer values must reset automatically when a user navigates to the page:
                    • Use the bookmark as the default state for the report page.
                    • Set the page to load with this bookmark applied.
 
Solution 2: Force DirectQuery Refresh. DirectQuery mode fetches data dynamically, but cached slicer data can                    still persist. Ensure your visuals are refreshing correctly:
 
    1.Enable Auto-Refresh for Visuals:
            • Go to File > Options and Settings > Options > Data Load.
            • Under DirectQuery, check Allow data previews to refresh.
     2.Use the "Refresh Now" Button:
            • Add a "Refresh Now" button in Power BI to force all visuals (including slicers) to refresh when  
                  clicked.
     3.Disable Data Caching for Slicers:
            • In slicer settings:
                       • Go to the slicer's Format pane > Data/Items and set it to dynamically refresh by 
                          ensuring no static filters are applied.
 

If this post helps, then please consider Accept it as the solution and give a Kudos to help the other members find it more quickly. If you have any other queries you can reach out to community forum for assistance.

Thank you.