Filtering table rows based on slicer values

[jayn123]

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?

[mahenkj2 · Accepted solution]

Hi @jayn123 

Is this your desired output:

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.

https://drive.google.com/file/d/1UJxotHe2vawB5i-jEYju3xJHvfrtFict/view?usp=sharing

Hope it helps.

[MattAllington]

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/

[jayn123]

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

[Ashish_Mathur]

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.

[Ashish_Mathur]

Hi,

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

[MattAllington]

Then add a second slicer for column B

[jayn123]

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.