Filter only on subset of Data

[Anonymous]

I have the following base table with category and quality:

I would like to have two filters for the quality values, one for category a and one for b. For example I'd like to filter for category a quality 2 and category b quality 1 and show the result in one table. Or be able to filter for a specific quality for category a and do not filter b at all.

I tried splitting the table and rejoining them with a calculated table but that doesn't seem to update on slicer change.

The result is supposed to look something like the following. I have slicers for each category and the result table basically is the union of those above which changes if I change the slicer values.

I'm relatively new to Power BI so I might have missed something fundamental, but I cannot, yet, figure it out. Any help is greatly appreciated!

[harshnathani]

Hi @Anonymous ,

Your Slicer Quality is one column in your table. 

You cannot segregate the Slicer by Category. The selection is your Slicer tells the engine to filter table by the selected quality value.

Can you let me know what is the end objective of this problem

Regards,

Harsh Nathani

[harshnathani]

Hi @Anonymous ,

You can use Slicers to show these Values. Pull 2 Slicers from the Visualization Pane and you can filter them through the slicers.

Incase you need to create a new table

New Table =  FILTER('Table','Table'[Category] = "a" && 'Table'[Quality] = 2 || 'Table'[Category] = "b" && 'Table'[Quality] = 1)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani @Pragati11 thanks for the quick reply. I updated the question to make it a bit more clear. The table looks good but I'd like to choose the values within the report and don't hardcode them in the table code.

[Pragati11]

Hi @Anonymous ,

You can try creating 2 slicers on your report:

1. Category
2. Quality

Try placing "Category" slicer before "Quality" slicer.

Now, suppose you select "a" in CATEGORY slicer, then in QUALITY slicer should have respective values in it for this category. Then select a value from QUALITY slicer to get the desired result.

Thanks,

Pragati