cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

## Filtering table rows based on slicer values

I'm using a slicer to slice my table based on value on column A. I have a sliced table and now column B has only values x and y (other values got sliced out).

Now, I aim to create a table visualization that displays all rows from the original table where the column B value is either x or y.

How could I achieve this?

1 ACCEPTED SOLUTION
Solution Sage

Hi @jayn123

If so, you can achieve by doing something like as in attached file, with the help of table transformations and then relationships. Its functionality shall depend on your actual data, I usually seldom go this way, reason is if, we follow a dimensional design, most reports are achieved in a much simpler manner. But occassionaly we may have to somehow achieve the result, then attached is just one of the way.

Hope it helps.

7 REPLIES 7
Solution Sage

Hi @jayn123

If so, you can achieve by doing something like as in attached file, with the help of table transformations and then relationships. Its functionality shall depend on your actual data, I usually seldom go this way, reason is if, we follow a dimensional design, most reports are achieved in a much simpler manner. But occassionaly we may have to somehow achieve the result, then attached is just one of the way.

Hope it helps.

Slicers are designed to filter your data and hence your visuals. You want to show the opposite (things that are left after the filter). This article I wrote a few years ago is not exactly what you need, but it may help you

https://exceleratorbi.com.au/items-not-selected-slicer/

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Regular Visitor

I'm sorry, perhaps I mis-phrased myself. I don't want to show whats left out of slicer. I wanna filter/re-slice based on the results of the original slicing.

I have table:

A  |  B  |   C
1     x      i8
1     y      i12
2     z      i10

2     q      i41
2     x      i99
3     y      i88

If I slice A=1, I get B values x and y. Now I wan't to filter/re-slice by B values x and y, so that I have following rows as result:

A  |  B  |   C
1     x      i8
1     y      i12

2     x      i99
3     y      i88

Super User

Hi,

Given this table in which A has 2 types - Type 1 and Type 2, the result (second image) wll show all those rows in the Table visual, which have the type as 1 and 2.

Hope this helps.

PBI file attached.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

Hi,

Why do you not just straight away apply a filter on x and y?

Regards,
Ashish Mathur
http://www.ashishmathur.com

Then add a second slicer for column B

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Regular Visitor

I can't apply slicer nor filter to Column B, because I do not know what values I should filter. X and y were just examples to clarify what I'm trying to achieve. I only know what I wanna slice by Column A.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors