Forum Discussion

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago
Solved

composite slicer strategy

Hello fellow bi'ers,     I have a slicer strategy question..I'm wanting something that looks like a heirarchy slicer--but it's really a composite, not a heirarchy. Here's a picture. In essense, th...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    ThomasDay

     

    In this scenario, you can create a new hierarchy. And then use the HierarchySlicer.

     

    1. In Power BI home page, right click the attribute which will be the top level of the hierarchy, selected “New hierarchy”.
    2. Right click the other attributes and select “Add to … Hierarchy”. A top-down hierarchy can be created by yourself now.
    3. Put the hierarchy you created into Fields of Hierarchy Slicer.

    Regards,

  • ThomasDay's avatar
    ThomasDay
    10 years ago

    From the author: 

    ----------------

    The current version of the slicer only allows multi-select if a item of a level only have one parent. If you look at your hierarchies: the single select version the ‘N’ and ‘Y’ items have multiple parents: ‘Disprop Share’, ‘RRC’ and ‘Teaching Hosp’. This will prevent the multi-select option.

    ----------------

    Apparently a new version is in the works in the next few weeks as Jan's figured out how to work around the issue.  Thanks in advance!

     

    Tom

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

ThomasDay

 

In this scenario, you can create a new hierarchy. And then use the HierarchySlicer.

 

  1. In Power BI home page, right click the attribute which will be the top level of the hierarchy, selected “New hierarchy”.
  2. Right click the other attributes and select “Add to … Hierarchy”. A top-down hierarchy can be created by yourself now.
  3. Put the hierarchy you created into Fields of Hierarchy Slicer.

Regards,

ThomasDay's avatar
ThomasDay
Icon for Impactful Individual rankImpactful Individual
10 years ago

Thanks all for the suggestions.  These are very versatile.  Creating column heirarchy is interesting and different than creating an unpivoted data set--both of which have their place.  Thanks for opening my eyes to the possibilities.  Tom