Forum Discussion
Helper IVSuper filter (slicer)
HI all,
Have idea.
I have more than 5 table with main data in table created by groupby (DAX)
How i can create the one filter (slicer) which will filter all table.
Actualy cant solve, table groupby, because it don't have column with DATA which i want filter, but it column has in main table.
5 Replies
- v-diye-msft
Community Support
Hi answeriver
You might consider creating pbix file that will contain some sample data, upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
- answeriver
v-diye-msft Hello, thank you for attention
I can do it, but before can you told me is it possible in general&
Because my data is confidential, but i can't made another data like example.
Repeat my question: I sit possible get slicer wich will filter main data and this action will projection on data which create with DAX groupby
- answeriver
v-diye-msft here is link to pbix file
https://drive.google.com/open?id=108NXnfk_tTiim69Wd320wXq7IglPKH9I
- v-diye-msft
Hi answeriver
Based on your sample, if you'd like to set the slicer in one table and affect the calculation in another table, there must be a relationship applied between them. but I can't manage the relationship in your data coz sheet1 is empty. also, the data is still too scarce to repro your actual problem. which is different for me to provide a valuable suggestion.
