cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Drill down two visuals

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.

Capture1-censoredCapture2-censored
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

@Steve6 ,

 

You may take a look at Use drillthrough.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

@Steve6 ,

 

You may take a look at Use drillthrough.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

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!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors