Forum Discussion
slicer won't update
What is the value for Strain Slicer from ? How did you update the Strain column ? what is your data source ? Which mode did you use to get the data from your data source ,Import or Direct Query or Live Connection ?
Can you describe your data structure and value method in detail ? Because I don’t know much about the way you get and update data, there is no way to judge your problem .
Looking forward to your reply !
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The value for Strain Slicer comes from the SKU Map table. The data source is an excel file. I'm actually not too sure if it is Import/Direct Query/Live Connection. How can I tell?
When you look at the photo I sent before of the Model, there are 8 files. 6 of them are updated on a weekly basis with the latest weeks' sales data. These are on the top row of the model.
The two files on the bottom row ("SKU Map" and "DateLookup") are also excel files, but these are updated on an ad hoc basis, only when new SKUs are added or I need to increase the date range. These are used to clean up the data from the other 6 files on the top row, which each have unique SKU numbers and date formats, depending on the data source. The SKU Map and DateLookup serve to match the unique SKU numbers and date formats to a common reference point.
When I update any of the files on the top row of the model, I can hit the refresh button and all of the new info gets updated and is included in the Graphs and Tables of the Report. The issue is with the Strain Slicer, which references the SKU Map file. When new SKUs are added to the list on the SKU Map file, they don't show up on the Slicer. The new information is updated and available in the graphs and tables of the report, but just not in the slicer.
I hope that explanation helps! And thanks so much for your responses. I really appreciated it!