Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Select All With Chiclet Slicer

Hi All,

 

I am trying to create a Select All using the Chiclet Slicer but I am running into a few issues. When I hit "All Product" the data blanks out. For context I followed the guidence in this answered question   thread. Heres a link to a test file where I attemped to create a Select All pbi .  

 

What am I missing here? I feel like it should be working.

 

Thank you

 

 

Need Help
Show and Tell
Tips and Tricks
  • OwenAuger's avatar
    OwenAuger
    4 years ago

    Hi Anonymous 

    If you want to have a "Select All" option on a Chiclet slicer alongside individual Products, I would recommend a slighly different approach.

     

    Sample attached.

     

    For your Product Slicer table, you can add a Product column which contains all the Products corresponding to each option in the Selection column.

    So All Products has all 5 Products, while the other options just have a single Product.

     

    Selection Product
    All Products Product 1
    All Products Product 2
    All Products Product 3
    All Products Product 4
    All Products Product 5
    Product 1 Product 1
    Product 2 Product 2
    Product 3 Product 3
    Product 4 Product 4
    Product 5 Product 5

     

    Then this table can be related (bidirectional) to an intermediate Product dimension (with just Product 1 to Product 5 in this example), which relates to your fact table.

     

    This removes the need for any measure-based filtering.

     

    Note: If you did want to pursue some sort of measure-based filtering, it would not work with the relationship you had between the tables.

     

     

    Regards,

    Owen

3 Replies

  • OwenAuger's avatar
    OwenAuger
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

    If you want to have a "Select All" option on a Chiclet slicer alongside individual Products, I would recommend a slighly different approach.

     

    Sample attached.

     

    For your Product Slicer table, you can add a Product column which contains all the Products corresponding to each option in the Selection column.

    So All Products has all 5 Products, while the other options just have a single Product.

     

    Selection Product
    All Products Product 1
    All Products Product 2
    All Products Product 3
    All Products Product 4
    All Products Product 5
    Product 1 Product 1
    Product 2 Product 2
    Product 3 Product 3
    Product 4 Product 4
    Product 5 Product 5

     

    Then this table can be related (bidirectional) to an intermediate Product dimension (with just Product 1 to Product 5 in this example), which relates to your fact table.

     

    This removes the need for any measure-based filtering.

     

    Note: If you did want to pursue some sort of measure-based filtering, it would not work with the relationship you had between the tables.

     

     

    Regards,

    Owen