Forum Discussion
Trouble with click on data using drill thru
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
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.
1 Reply
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.