Trouble with click on data using drill thru

[Babbs]

I have 1 table with columns item_category, Item Effect, Item_description , Item_detailName, Qty

item_category	Item_Effect	Item_description	Item_description	Qty
A	Can	Liquid	A	1
A	Halo	Solid	B	2
A	Halo	Liquid	C	3
B	Can	Solid	D	2
B	Halo	Solid	E	6
B	Can	Liquid	F	2
B	Can	Liquid	G	3

I have 3 visuals in page.

Visual 1 - Sum of Items by ItemCategory (Matrix)

Item_Category
+A
	Can	1
	Halo	5
+B
	Can	7
	Halo	6

Visual 2 - Details (tablular)

So when I click on Can for category B (Highlight Red), it gives me 3 records on table.

item_category	Item_Effect	Item_description	Item_description	Qty
B	Can	Solid	D	2
B	Can	Liquid	F	2
B	Can	Liquid	G	3

Which works fine using drill thru feture. But when I click on any Item Description (F), then in first visual I just see one row like this

Item_Category
+B
	Can	1

How Can I make the visual 1 to remain with same aggregation when I click on any of the Item_Description in Visual 2.

Viual 3 Graph
When I click on any of the ItemDescription (F), it creates the graph for that item_description.

SO to keep the Visual 1 aggregated numbers to show all, I habe to click on Total in Visual 2, but that mess up visual 3, coz visual 3 now do not know how to create graph for total.

Thanks,

Babs

[Anonymous · Accepted solution]

Hi @Babbs ,

through to drill down into the data, there's a logical hierarchy within it, it will filter the data you select logically, I think you can check out this document to learn more about Drill through: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn
If you want to go to the first page of the visual object after the third page of selection, then I think you can use Bookmark, which can help you go back to the original visual object.

I create a bookmark and a button.

Then I get a connection between them and we can click on the button, it will show us the visual you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.