Drill down two visuals

[Anonymous]

Hi,

I have a) matrix with 2 rows (teamleader name, trader name)

b)  a treemap with columns with the same content as the matrix

When I drill down in either of them, it works properly for the chosen visualisation but in the other one another visual level filter is created with the teamleader name and it shows just that teamleader's name and the summary of their traders' results, not the results of individual traders.

My second question is if there is a way to show different values when drilled down? At the start I want to see the summarized sales of two products, when I drill down I want to see the indivual amounts of those two products.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at Use drillthrough.

[romgut]

I like that functionality but from my point of view the explanation in the Docs is not 100% clear.

I would recommend to read the link provided in the solution and remember those main steps:

1) in your visual, drag and drop a field to the drillthrough target (same field as in your visual, in my case the month field)

2) Power BI will automatically create a "go back" button in your top left corner, you can cut & copy that button to your drill-through page

3) create a new page (you can make it hidden) with your new chart

4) drag and drop the same field, same as you used before, in the drillthrough of this new page. Do the step 2)

5) Power BI will take care of the automatic filters 

You can now go to your visual and right click - drill through

p.s. in the docs page, there is a link to another page which shows how to create buttons for the drill-through - have a look at it!