Forum Discussion
Slice auto filter
Hi kindakaa ,
Thanks for the quick reply Gabry , as Gabry said, as of now it's not possible. But I have an alternative idea:
You mentioned that you used different slices to find the 20 worst stores out of the 1,000. Not sure if you presented these 20 stores as a visual object in a table or as a slicer, either way, you have the option to export the data. Then select get data -> text/csv, select the csv you just exported, select "transform data", click on "make the first row the header", and then save and close so we have a table of stores with 20 rows. Then we will use it as a DIM table to create model relationships with other tables so that we can create slicers to filter other tables.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In fact, the task is more difficult. I want to select the several stores with several slices - save the selected stores as a slice. And clear the other slices. And then analysis sales only for selected stores.
Sorry I don't understand what you mean, could you articulate more?
What do you mean with select several stores with several slices and save the selected stores as a slice?
could you paste a screenshot of your report?
Sorry, I cant paste screenshot. I'll try to explain. I analyze more than 1000 stores. I have sales of different products on them. Using different slices, I found the worst 20 out of these 1000 stores (in my opinion). I somehow need to save these 20 stores as a slice so that I can work only with them on other pages of the report. I can't save the rest of the filters. For example - I filtered sales only for the new year to find out which stores sell poorly for the holidays. That is, in the future I cannot save the filter by date. You just need to somehow select certain stores for work and continue to work only with them.
Ok, I think I understand. You perform some analysis on the first report and identify stores that need further analysis. How can you keep the filter applied only to those stores?
Here's what I suggest: add a store filter to every report page and sync these filters. On the first page, after detecting the stores you need to analyze, use a "Select All" button to apply this set of stores to the filter. This way, all the pages will be filtered to show data only for these selected stores.
Could this be an optimal solution?
Unfortunately, when I click "select all" - the filter saves all stores. Even the ones that are not visible. But if you manually select all 20 stores, synchronization works.