Why does my second filter remain on an option that shouldn't exist?

[HamidBee]

Let's say I've chosen "Customer Service" and "Call Center":

If I choose "Finance", I find that "Call Center" is still selected. "Call Center" is not a sub category of "Finance" and so it should not be there.

It takes me selecting "Auditing" inorder for "Call Center" to disappear. 

Here is a link to the updated file:

https://www.mediafire.com/file/z9a3o5bu64rmu4r/Filter.pbix/file

Once again, your help is greatly appreciated. 

[HamidBee]

Thanks for getting back to me. Do you think there is a measure for removing the specific sub division from the filter if they don't exist in the division?. The issue is I end up with blank visuals in the example above. For example, there is no "Auditing" in the "Finance" business unit. 

[lbendlin]

The only workaround is for the report developer to NOT specify any default filter values before publishing.  But that is not good advice either...

[lbendlin]

That is working as designed.  Not saying it is a good design. Even has the potential for data leakage, especially in RLS scenarios.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41