How to drill through multiple values of a column

[amaaiia]

Hi,

I have a page with one slicer for field1, one slicer for field2 and a visual table with several fields.

I want to add a button to click drill through so the values filtered from field2 (only field2) are passed to the other page.

I've seen this video (https://www.youtube.com/watch?v=s7PSwxdiwwE) and it works, however, it passes all the filters, not only the ones from field2.

How can I pass only values filtered from field2?

Another related question: if I SELECT ALL values from slicer with filter2, values are selected but they are not passed to the other page, because a select all is not a select of specific values. Is there any way to select all values from a slicer and make them appear in filters tab as:

field2 is XXXX, AAAA, YYY and not as all selected? 

[v-achippa · Accepted solution]

Hi @amaaiia,

Thank you for reaching out to Microsoft Fabric Community.

Yes, by default power bi passes all active filters to the drillthrough page, including field1 and field2. To pass only the field2 filter, create a dedicated drillthrough page and use a visual for ex a table visual so that it includes only field2 values for triggering the drillthrough. And also, make sure the drillthrough page is configured with only field2 in the drillthrough field well.

And regarding the "Select All" option, power bi will treat it as no filtering, so no specific values are passed. So to achieve it, create a disconnected slicer table that includes an "All" option and use this table in the slicer instead of the original field2. And then use a DAX measure to interpret the slicer selection and return all values of field2 when "All" is selected.

This approach allows to pass explicit values, even when selecting all, and keeps the drillthrough logic clean.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @amaaiia,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa