filter showing default value which is not there if i set the filter to another value

[PatrikK123]

How can I set it in a Power BI visualization report so that if I have two filters, it doesn't constantly display the default value from the first filter - the first option, if I select a different option? Here is an illustrative example:

and if i click to another value - polrok, there is still in second filter the value cely rok, but this value is not in the first filter, how to change it? 

So there should be, in second filter, just value H1.

[v-jianpeng-msft]

Hi, @PatrikK123 

If the fields used by both of your slicers are in the same table, you can traverse the filter's filter relationship to set the slicer to normal:

In the following scenario is what you are experiencing right now:

I was able to reproduce your current problem when I clicked on rock in slicerB and pol rock in slicerA:

You need to enable mutual filtering for your two slicers, just like the two images I provided earlier, and after that, you can get the results you are looking for.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PatrikK123]

not working for tile filtering, because there ist still default value clicked:

[v-jianpeng-msft]

Hi, @PatrikK123 

After my testing, this is by design. For this purpose, I created a simple sample data as follows:

To verify whether the additional unmatched filter items have an impact on the results, I created the following metric:

Measure = SUM('Table'[Index])

When I select H1,H2:

When I select YTD, H1, H2 in the slicer, although the slicer retains the unmatched items, it does not affect the final result:

This is the default behavior of the slicer, which will keep the currently selected item. However, if the currently selected item does not match, it will not affect the data. 

I have provided the PBIX file used in this article below. I hope it will help you understand the behavior of this slicer.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PatrikK123]

ok, and can u tell me how to do it better for user experience? this slicer is not good for this filtering.

[v-jianpeng-msft]

Hi, @PatrikK123 

Thank you very much for your reply. You can follow the articles below to optimize your reports to improve the user experience:

Enhance Power BI report designs for the user experience - Training | Microsoft Learn

Power BI Slicer Tutorial: A Comprehensive Guide to Enhancing Your Reports | DataCamp

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PatrikK123]

I have data like this:

filter A	filter B
rok	rok
rok	YTD
pol rok	H1
pol rok	H2

and if i click to filter A to value rok i see just value rok and YTD, it is default. But when i click in filter A to value "pol rok" I see default value from filter A set to value rok - filter B rok, ant it is showing none data, because it is not there when i have in filter A value pol rok. How to adjust it?