Forum Discussion
Slicer Select All Option not working as expected
- 2 years ago
Thankyou Anonymous and PijushRoy for your solution.
Anonymous had the correct understanding ,
Apologies for not able to explain the problem statement before but my requirement was as given below :
- End User wanted to get all the associated TEST IDs where a certain product has been involved by using the slicers
- After above step, once we get the list of TEST IDs in the slicer, I should be able to see the TEST RESULTS in child page but the graph should contain all the products involved in the TEST ID
Example :
If I select Region = Asia ,
&& Product Name = PrdouctAsia then
I get all the associated TEST IDs where " Product Asia " is involved
Now If I select TEST ID = 101 and go to the child page, the expected output (for test ID - 101, there were total 2 products involved which should come) as given in the below snapshots :
Now for the above scenario, even if you click on SELECT ALL from TEST ID slicer, you will be receiving the output as shown below :
The solution has been achieved by implementing below steps :
- Creating new summarized table where I had all the combination present
- creating many to many relationship between FACT Table and Summarized Table based on TEST ID column
- Using the columns in the slicers from summarized table
- Synchronizing all the slicers from parent page to child page and hide it from selection pane
- the table visual in child page was coming from FACT Table
both the tables looks like below (unable to attach the PBIX files here) :
FACT TABLE :SUMMARIZED TABLE :
Thanks,
Ankita
Hi AnkitaaMishra
You have only SalesOrderLineKey sync in Page 3 and Page 4
In Page 3, only 3 LineKey are showing after applying the Category, Sub Category, and Product filter
These Category, Sub Category, and Product these filters are not sync in Page 4 and all SalesOrderLineKey are showing in visual
You should have Category, Sub Category, Product & SalesOrderLineKey sync between Page 3 & Page 4
You can update sample PBIX file in Google Drive/Dropbox/OneDrive and share the link
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin