Hi, I wanted to know if there is an option to do a drill through from the total line of the table? Thanks!

udian, There isn't such an option. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.

Drill Through from Total Line | Microsoft Fabric Community

v-chuncz-msft
Community Support
8 years ago
udian,

There isn't such an option. You may submit an idea via https://ideas.powerbi.com/forums/265200-power-bi.
- udian
  Helper III
  8 years ago
  Will do :)
  
  Thanks!
  - Anonymous
    Not applicable
    7 years ago
    Hello, if you submitted an idea to add drill through functionality to total lines can you add the link here? I would like to vote up your submission. I am having a hard time locating it on the Power BI community site.
    
    Thank you!
Anonymous
Not applicable
7 years ago
My workaround is to turn the table into a matrix and then add a top-level group (eg if I my original first column was UK regions such as North, Central, South West etc, then I'd create a new first column called 'Country' and populate the rows with 'UK' or 'England' etc). I'll then add the +/- option in the matrix formatter so that when the matrix is collapsed to England/UK people can then drill through. I also ensure that my drill through page (usually a table of the entire dataset) has similar filters so that people can just use this page to get to the information they need - perhaps in combination with sync slicers. I'll vote up the option to drill through on the total line though as it's more convenient and intuitive.