Forum Discussion

AnkitaaMishra's avatar
AnkitaaMishra
Icon for Super User rankSuper User
2 years ago
Solved

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, Subcat...
  • AnkitaaMishra's avatar
    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