Dynamic Row Selection Based on Slicer

[rjk252]

Hi BI Community!

I have three seperate slicers on a report for three different levels of a hierarchy.

Slicer 1 is for Hierarchy A

Slicer 2 is for Hierarchy B (Subhierarchy of A)

Slicer 3 is for Hierarchy C (Subhierarchy of B)

The entire hierarchy is contained within one table and each hierarchy level is a different column, so values adjust easily for charts and matrix views.

My question revolves around the matrix visualization.  I have the row set to one of the columns that define hierarchies A, B, or C.  So if I'm looking at summary charts at level A, I have set the matrix visualization row to level B (basically a drill down of what makes up level A).  

Is there a dynamic way to change the row?

So if i select a slicer in Hierarchy B, the 'drill down view' in the matrix visualization row will change to level C?

I currently have to setup different tabs to do this, but it's repetitive and would like to minimize unneeded duplication.  Your help / insights is appreciated!

[MFelix]

Hi @rjkwte,

If you add A, B e C to an hyersrchy (right button) on top of the field you can the add that hirarchy to.you visuals and do a drill down with double click.

Chech this.link https://powerbi.microsoft.com/en-us/documentation/powerbi-service-drill-down-in-a-visualization/ with the latest version of Power BI desktop drill down is also possible in tables and matrix.

Regards,
MFelix

[dkay84_PowerBI]

Maybe it's just my early afternoon fatigue, but could you post some screen shots of what you have and would like to acheive so it is easier to understand?  Also posting some sample data or link to pbix file will help.

Thanks