Select Use all from both Subcategory and Manufacturer Filters.

It is working fine. May you're doing something wrong. See attached file.

Hi Neelakantha,

Please find attach the workbook. Hope this helps.

Thanks,

Himanshu Goyal

Hi,

How about this? Its good to avoid the dimension filters and use dashboard action filters which is more efficient.

Mahfooj

could could try with all values in hierarchy instead of only relevant values. This option is available in 2018+

I don't think its possible with all your conditions . You've to show "All" and before selecting different category you've to clear the filters from Sub-cat and Manufacturer quick filters. Or best way action filters though you need to think how and where to put these items in your view. It will occupy some additional real estate of your dashboard but it will be very efficient for sure. You can try this.

Okay got it. Here is a workaround. Follow below steps.

1. Add the Category filter to Context.

2. Right click Subcategory Filter and Select All values in the context.

3. Right click Manufacturer filter and Select Only relevant values.

Here you go!