Slice auto filter

[kindakaa]

Hi/ I have a table of stores and a table of sales in these stores. I have created a slice that filters sales over a certain amount. I have a second slice that shows the names of the stores. The first slice filters the second slice and I see in it only those stores with my conditions. However, the second slice does not automatically filter other visual elements, but begins to filter only after I change it with my hands. Is it possible to make the second slice work automatically? Sorry for English, guys.

[Anonymous · Accepted solution]

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. 

[Gabry]

Hello,

@kindakaa

I don't think it's possible to automatically set a value on one filter based on a selection in another filter.

However, this is a tricky question. If your first slicer filters the data to only include certain stores, you don't need to select those stores again since the data is already filtered for them. Then, if you want to further narrow it down to specific stores within that filtered set, you can make your selections accordingly.

[kindakaa]

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.

[Gabry]

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?

[kindakaa]

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.

[Gabry]

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?

[kindakaa]

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.

[Gabry]

How is built your model? Star schema? Use a new stores filter that gets the column directly from the fact table, this filter should get filtered by the others filter, so when you select all you should select only those available in the current filter context