Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi. I have a report with 4 tabs. The first tab (Overview) has a table. I have setup drillthrough from this to the 3 other tabs (Labour, Materials, Transport).
My issue is that when I drillthrough to Labour for example, if I then want to see Materials or Transport for that same item I have to go back to my Overview tab again, find the line in table, and drillthrough to Materials or Transport.
Is it possible that I can navigate between tabs keeping the initial drillthough filter? This would make the report more user friendly and easier to navigate.
Hope that makes sense, many thanks for any help.
Regards
Steven
Solved! Go to Solution.
Hi @sanderson82 ,
You can keep all applied filters to the drillthrough window when setting the Keep all filters toggle to on.
If you want to view other column values without having to return to the main report page again, all you need to do is change (or reset, if you like) the filters that are applied to the report page, and you can add new filters too.
For more information, please refer to:
Power BI Drillthrough Filters and How to Change Them
Use drillthrough in Power BI Desktop
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sanderson82 ,
You can keep all applied filters to the drillthrough window when setting the Keep all filters toggle to on.
If you want to view other column values without having to return to the main report page again, all you need to do is change (or reset, if you like) the filters that are applied to the report page, and you can add new filters too.
For more information, please refer to:
Power BI Drillthrough Filters and How to Change Them
Use drillthrough in Power BI Desktop
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-joesh-msft I set this and managed to achieve what I needed by adding the table from the first tab to all tabs (obviously filtered on the additional tabs). This allowed me to drillthrough to other tabs as required.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |