Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
jayn123
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
mahenkj2
Solution Sage
Solution Sage

Hi @jayn123 

 

Is this your desired output:

 

mahenkj2_0-1713178151430.png

 

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.

View solution in original post

7 REPLIES 7
mahenkj2
Solution Sage
Solution Sage

Hi @jayn123 

 

Is this your desired output:

 

mahenkj2_0-1713178151430.png

 

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.

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.

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

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.

Ashish_Mathur_0-1713174855238.pngAshish_Mathur_1-1713174866006.png

PBI file attached.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.