Hierarchy Slicer: also include parent level in selection

[bobsel]

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

If I select a level2 it automatically selects all the level 3's beneath it, but it also needs to select it self (level 2, cause there are also facts registered on the parent level)

so:

lev1

     Lev2.1

     lev2.2  ( <--- also include parent)

             lev3.1

             lev3.2

             lev3.3

     lev2.3

     lev2.4

How to do this with PBI desktop - HierarchySlicer?

[v-chuncz-msft]

@bobsel,

Check the sample report and you might need to add a calculated table.

[bobsel]

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]

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