Forum Discussion
Super UserSlicer Select All Option not working as expected
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 I am glad to help you.
Hello,PijushRoy.Thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Has your problem been solved? If not, you can refer to my test below.
Hello, according to my tests, you need to enable slicer synchronization for all four slicers if you want to get the expected results.
According to your understanding, after the four slicers have been affected by the other three slicers, there are only three options left (in fact, the total number of options of the fourth slicer SalesOrderLineKey is more than the three options after filtering), at this time, if you select selectall, it should only filter out the rows of data of the corresponding three options on the fourth page. SalesOrderLineKey enabled cross-page synchronization, so in the actual filtering situation, only SalesOrderLineKey played the final filtering results, and at this time the option is selectedall, so you see the result is to display all the data!
The following is the test I carried out:
I only set up the animal column to have the slicer synchronization function, the other two fields of the slicer is not turned on
At this point, the filter conditions should satisfy the three common filter conditions
The selection for animal is select all.
But the actual result is as follows: all the data is displayed incorrectly (in fact, the current filter condition only exists "animal"="select all") and the other two slicers do not play a real filtering role.
The suggestion PijushRoy has been tested and is correct, you need to turn on the synchronized slicer function for all four fields of your page3 slicer and apply it to page 4 so that the expected results are displayed correctly.
Here are some other issues that have been resolved and we hope you find them helpful.
url:
Solved: Re: How to make my selection in 1 slicer effect al... - Microsoft Fabric Community
Slicers in Power BI - Power BI | Microsoft Learn
If this post helps, then please accpet PijushRoy's suggestion as the solution to help the other members find it more quickly.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
- AnkitaaMishra
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