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 a...
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

OwenAuger's avatar
OwenAuger
Super 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

  • hughesaz's avatar
    hughesaz
    New Member
    2 years ago

    Thank you Owen.