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.
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.