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

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

ThomasDay you can try power bi custom visuals gallery there are number of slicers available there including hierarchy and attribute slicer.

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

    ankitpatira Yes, true enough.  The heirarchy slicer works when the data is in a heirarchy (productgroup-subproduct-product.  multiple columns, each with it's own row).  So, the assessories group of products has a bunch of bike types, and then bike models.

     

    I have a row with a bunch of attributes--one row, many attributes as columns.  Kind of like saying, I'm looking for people 6' tall, with brown hair, one arm, and yellow eyes.  Right now I have one row per person with the attributes in columns.

     

    So perhaps the problem is just the structure and I need to create a related table with a column of attribute names and values for each "person" then use a slicer from there.  OK, that's helpful