How to set action filters in Power Bi?

[gpvardhan]

Hi Team,

I have two reports, these two report coming from two different tables(Table A and Table B)
Table A is contains summraised data and Table B is full details data, I have created both martix table visuals ,when i clik on particlular column in Table A matrix table data it will redirect to Table B matrix chart with include all filter? how can we do that in Power Bi???

[amitchandak · Accepted solution]

@gpvardhan , Either Table A is the master table joined with detailed table or they need to have common dimensions

Create a visual using common dimension (Table A or Set of common Dim) with measures and then you can use drill through to drill across page or report

Cross Report -https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through
Within report - Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

refer if needed

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...