Forum Discussion
Resolver IEnabling Drill Through button for Horizontal Total in Matrix
I directly created a table by selecting Columns from original table with additionally creating rows like all marketers, all categories. then added this in the matrix and disabled row total. this all rows, all marketers,,, will act as totals
Super UserPremK , Horizontal total to me seems like Grand total, so I doubt you will get. But check if you add the measure to the drill-through page's drill-through (where you added the category )
Drill through on total
Resolver IHi amitchandak,
I couldn't understand your point. can you pls clarify me with bit more details
I want to drill through from the bottum total
- v-venuppu
Community Support
Hi PremK ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you amitchandak for the prompt response.
Why Drill-through Doesn't Work on Horizontal Totals (Bottom Total Row):
The bottom total row in Power BI Matrix visuals represents an aggregate (Grand Total). This row doesn't contain the actual category context, which is what the drill-through functionality needs to work properly.You Can Try Below:
To make drill-through from that total row work (or simulate it), here's a more detailed explanation:
1. Add Measures to the Drill-through Page Filters:
In your drill-through page, make sure you're not just adding categories (like "Brand" or "Marketer"), but also add the Measure (like "Revenue" or "Net").- Go to the drill-through page.
- In the "Drill-through" pane, under “Drill through from”, add both:
- The category (e.g., Marketer)
-
The measure (e.g., Revenue)
-
This makes the page aware of what value you're trying to pass, even from total rows.
2. Use a Separate Visual as a Workaround:
If you're trying to drill through from the total (bottom horizontal row), consider creating a card visual or custom button that passes predefined filters when clicked. This simulates drill-through for the grand total.
3. Use DAX to Identify Totals:
Create a DAX measure that checks if the current row is a total using ISINSCOPE() or HASONEVALUE():
IsTotal = IF(ISINSCOPE('Table'[Marketer]), "Detail", "Total")
Then use this to enable actions or conditional formatting, or as part of your drill-through logic.If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.