Showing results for 
Search instead for 
Did you mean: 
Memorable Member
Memorable Member

Drill trough on cell granularity

It would be great if you could help me find a solution for my client.

He is using a report server.

Loading tables calculated in the source saves time.

DAX is not used at all.

Data is presented in a matrix with categories on each row
Daily and monthly amounts calculated in two columns.

He is looking for a way to make each entry into a more detailed table on row transactions granularity.

By using the "drll through" option
In this case, he does not get the desired result since he reaches tables that are only filtered by category
He also wants a breakdown of the cell (combining the category and the calculated column).
Is there a solution to this?

Solution Sage
Solution Sage

Hi @Ritaf1983 ,

You mean only one of the calculated columns should be shown after drill through based on the selected cell?


If yes, One way is creating 2 separate pages, and in one of them add "Category and Calculated column1" as Drill through fields on the page

and add "Category and Calculated column2" as Drill through fields on the second page.


Then the end user can select to drill through which one of above-mentioned options.


If this answer solves your problem, accept it as a solution so others would find what they need easier.



Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors
Top Kudoed Authors