Fixing a hierarchy for a slicer

[Anonymous]

Hi,

I have a brands table, let the following represent the table:

Brands

brand A

brand B

brand C

brand D

brand E

brand F

brand G

brand H

brand I

brand J

I have made this table using the DISTINCT function from the main table. Now some of these brands are the child brand to a parent brand. So lets assume brand B, brand E, and brand H belong to brand B. So, I wrote some DAX code to add a column to the same table which compares the values and generates something like the following:

Brands   |	Combined Brands
brand A |	brand A
brand B |	brand B/E/H
brand C |	brand C
brand D |	brand D
brand E  |	brand B/E/H
brand F  |	brand F
brand G |	brand G
brand H |	brand B/E/H
brand I   |	brand I
brand J  |	brand J

This new table I have added to the slicer on my visual where I have added the combined brands first and then brands as the second value to the field for the slicer, but the problem is that when I click on the drop down the slicer shows all the single brands as well with a drop down to the same brand name, for example it displays down arrow on brand A to expand and it expand to brand A, however incase when it display down arrow to expand brand B/E/H it expands to Brand B, Brand E and Brand H. How can I get rid of these single drop downs as they are not required( such as brand A, brand C, brand D, brand F) ?

Thanks.

[jcalheir]

Hi

A good rule of thumb would be to redesign your model creating two tables, one with the actual brands and another with the child brands like the following picture.

Then it will be way easyer to filter your visuals with either Parant or child brands.

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂