topic Re: Filter only on subset of Data in DAX Commands and Tips

Filter only on subset of Data

Anonymous — Tue, 23 Jun 2020 12:40:13 GMT

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!

Re: Filter only on subset of Data

Pragati11 — Tue, 23 Jun 2020 10:14:39 GMT

Hi Anonymous ,

You can try creating 2 slicers on your report:

Category
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

Re: Filter only on subset of Data

Anonymous — Tue, 23 Jun 2020 10:16:14 GMT

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)

Re: Filter only on subset of Data

Anonymous — Tue, 23 Jun 2020 12:43:23 GMT

Hi Anonymous 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.

Re: Filter only on subset of Data

Anonymous — Tue, 23 Jun 2020 19:33:42 GMT

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