Forum Discussion
Slicer not updating when source data is updated
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
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?