Slicer Select All Option not working as expected

Hi All,

Need help with below usecase :

I have few slicers on Page 3 and one of the slicer "SalesOrderLineKey" which is multi-select and is in sync for Page 3 and Page 4.
The Category, Subcategory and Product slicers are used to get the associated "salesorderlinekey".

When I am explicitly selecting SalesOrderLineKey values from slicer and use the button "click to see results", i see the expected result in page 4 as shown in below two snapshots : (i.e. two key selected the expected result is associated 2 records)

but when I am selecting "Select All" option for SalesOrderLineKey Slicer, then the output is not coming as expected as shown in below snapshots : (i.e. only associated 3 records should appear in Page 4)

Unable to attach the sample file here.
Please let me know if you guys have any idea to fix this.

Thanks!

Need Help

AnkitaaMishra
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

3 Replies

PijushRoy
Community Champion
2 years ago
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
Anonymous
Not applicable
2 years ago
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
testcase04_7_8_.pbix55 KB
- AnkitaaMishra
  Super User
  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