Forum Discussion
Slice auto filter
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.
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.
8 Replies
Hello,
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.
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?
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.
