Drillthrough Complications

[Anonymous]

Hello, 

I have a drillthrough filter that I want to not apply to all visuals.  I understand then when drilling through to another page you are applying all the drillthrough fields to the target page (and yes I need to select "keep all filters").  On my target page, I have a KPI which I want 12 months of data to show for.  On the page before (that I am using to drillthrough) I am selecting one month and that is affecting my filter context that gets passed through.  The data I need to be unaffected is on the trend axis of the KPI, and it's my understanding that you cannot apply measures to an axis (so I think that takes calculate/all out as a possibility).  Also, I don't think there is a way to "edit interactions" between multiple pages - only on same page.  Any other ideas or ways that you could limit this filtering ? 🙂 I am stumped. 

Thanks! 

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can use a separate duplicate table as a workaround  to make the visual did not affected by Drillthrough filter, but it will also be excluded from other filter or interaction in this page.

Please also refer to this similar thread: https://community.powerbi.com/t5/Desktop/Disable-drillthrough-for-few-visuals/td-p/347182

Best regards,

[Anonymous]

Thanks @v-lid-msft.  I think this will do as a workaround!  A little suprised the solution linked in your reply works - I would think by duplicating the column the table would still be filtered in the same manner as it was before.  Seems like your suggestion, to create a duplicate a table is more appropriate.