Hierarchy Slicer: also include parent level in selection

Question

I'm using a HierarchySlicer to filter my fact data in PBI.The hierarchy is stored flattened in one table&nbsp;&nbsp;The facts are registered on all levels (so level 1,2, and 3). Not only one level3&nbsp;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:&nbsp;lev1&nbsp; &nbsp; &nbsp;Lev2.1&nbsp; &nbsp; &nbsp;lev2.2&nbsp; ( &lt;--- also include parent)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lev3.1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lev3.2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lev3.3&nbsp; &nbsp; &nbsp;lev2.3&nbsp; &nbsp; &nbsp;lev2.4&nbsp;How to do this with PBI desktop - HierarchySlicer?

v-chuncz-msft · Answer

bobsel,
&nbsp;
Check&nbsp;the sample report&nbsp;and you might need to add a calculated table.

bobsel · Answer

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 · Answer

Hello,Did you solve it by any chance?&nbsp;I have a similar issue, i wanted to filter/hide few rows based on a condition.&nbsp;Thanks,Soumya

Forum Discussion

Hierarchy Slicer: also include parent level in selection

3 Replies

Related content

Dynamic Subtitle with Hierarchy Slicers

Selected slicer

Slicer default selection

Single select slicer

Slicer and Visualization Hierarchy