Drill Through for Tables Aggregated in Power Query

Power BI
1

Hello all, a bit new to Power BI and DAX.

I have a Power BI report developed by pulling data from various data sources and aggregated into 3 tables of KPI’s in Transform Query and then presented in Power BI as Matrix visuals.

Will it be possible in Power BI to have a drill through that can show details of data from the aggregated data sources or do i have to bring the tables individual into Power BI and use DAX to do the aggregation and generating the KPI’s for this to work.

2

Hi @Obi

Thanks for posting your query in the forum

Please share us the sample PBIX file and screenshot of the sample solution you are looking at, this will help us to answer your query…

You can also refer to the below link for more details on Drill through

1 Like
3

Hi @Obi, did the response provided by @Dharma help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

4

Hi @Obi due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.