Forum Discussion

bobsel's avatar
bobsel
Icon for Helper I rankHelper I
8 years ago

Hierarchy Slicer: also include parent level in selection

I'm using a HierarchySlicer to filter my fact data in PBI. The hierarchy is stored flattened in one table     The facts are registered on all levels (so level 1,2, and 3). Not only one level3   ...
Need Help
bobsel's avatar
bobsel
Icon for Helper I rankHelper I
8 years ago

I've checked the sample report but the data in it, is not reflecting my situation.

 

In my situation the data looks like this:

So we've got revenue rows, which are registered on the Prod Sub Cat "Road Bikes"  but we don't know on what Product.

But If we select "Road Bikes"  in the Hierarchy Slicer WE DO WANT TO ADD this revenue.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello,

    Did you solve it by any chance?

     

    I have a similar issue, i wanted to filter/hide few rows based on a condition.

     

    Thanks,

    Soumya