Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Babbs
New Member

Trouble with click on data using drill thru

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

item_categoryItem_EffectItem_descriptionItem_descriptionQty
ACanLiquidA1
AHaloSolidB2
AHaloLiquidC3
BCanSolidD2
BHaloSolidE6
BCanLiquidF2
BCanLiquidG3

 

I have 3 visuals in page.

 

Visual 1 - Sum of Items by ItemCategory (Matrix)

Item_Category  
+A  
 Can1
 Halo5
+B  
 Can7
 Halo6

 

Visual 2 - Details (tablular)

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

item_categoryItem_EffectItem_descriptionItem_descriptionQty
BCanSolidD2
BCanLiquidF2
BCanLiquidG3

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  
 Can1

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

1 ACCEPTED SOLUTION
v-yilong-msft
Community Support
Community Support

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.

vyilongmsft_0-1713327359031.png

vyilongmsft_1-1713327396432.png

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

vyilongmsft_2-1713327542829.png

vyilongmsft_4-1713327591420.png

vyilongmsft_3-1713327567519.png

 

 

 

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.

View solution in original post

1 REPLY 1
v-yilong-msft
Community Support
Community Support

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.

vyilongmsft_0-1713327359031.png

vyilongmsft_1-1713327396432.png

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

vyilongmsft_2-1713327542829.png

vyilongmsft_4-1713327591420.png

vyilongmsft_3-1713327567519.png

 

 

 

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.