Select All With Chiclet Slicer

[Anonymous]

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

[Anonymous]

@OwenAuger thank you so much this is perfect

[OwenAuger · Accepted solution]

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]

Thank you Owen.