Keep dependent Filters

[GS2605]

Hello,

I have a question regarding the management of filters in reports: If I apply a filter for the attribute "Salesperson", I only see the customers associated with that salesperson. How can I then filter precisely for these customers to check if they have also made purchases from other salespeople? Currently, the only approach I see is to individually select all the values displayed under the "Customers" attribute. For salespersons who have well over 100 customers, this process is quite tedious.

Is there a way to select all the currently displayed filter values and retain these filters when the original salesperson filter is removed or expanded? The "Select All" option results in all customers being displayed again after removing the filter for the salesperson. And it appears there is no option to mark an entire range using CTRL and SHIFT, for instance. Does anyone have a solution?

I hope I've explained my issue clearly. Thank you in advance!

[v-achippa · Accepted solution]

Hi @GS2605,

Thank you for reaching out to Microsoft Fabric Community.

Power BI does not provide a built-in way to retain dependent filter values after removing the original filter. When a primary filter is cleared, the related selections reset to their default state, showing all available data. This behaviour is by design, and there is no direct feature to maintain filtered selections once the original filter is removed.

I recommend submitting your detailed feedback and ideas through Microsoft's official feedback channel. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

https://ideas.fabric.microsoft.com/ideas/search-ideas/

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 @GS2605,

As we haven’t heard back from you, we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum, we are ready to assist you on it.

Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[GS2605]

Thank you for your response. However, the mention of salespeople was just an example. It could be a different attribute that I wish to filter on initially and for which I would like to keep the displayed values. This feature should also be accessible to users who can only open the reports in read-only mode.

[BhavinVyas3003]

Hi,

You can try to create a calculated table with only distinct customers based on the applied Salesperson filter and Use this table as a filter for further analysis.

SelectedCustomers = VALUES(Sales[Customer])

Thanks,

Bhavin