Forum Discussion
Amanda2503
Jun 20, 2022Copper Contributor
Slicer not updating when source data is updated
Hello, I have a dashboard showing project data with multiple pivot tables. There are two slicers that are connected to all the pivot tables, Project ID and Project Status, these used to update w...
Znowlin
Jan 17, 2024Copper Contributor
SergeiBaklan Hi. I am having a similar issue with Slicer not updating when source data is updated in the query, specifically I added a new file w/ data to the query aggregator. I tried your suggestion below w/o success. I see the new data in the pivot table / query (from the newly added file) but not in the slicers. If I create a entirely new pivot from the updated query tab then the slicers are updating correctly, however I do not want to recreate my pivot tables. thanks
Znowlin
Jan 17, 2024Copper Contributor
post note.. now if I filter the new data in the pivot directly then I see the data in the respective slicer but it is "grayed out" as if there is no data. I can select the gray out slicer category to filter the pivot table. Question: How do I get the slicer to format the category to be the same "blue" as the other slicer categories (e.g. have data.) Otherwise this will be confusing to the user.. categories with data vs no data.
If I unclick "visually indicate items with no data" then the issue go aways, however this seems not logical.. what am I missing here?