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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
kha_powerbi
Frequent Visitor

Flittering two columns with one slicer

I have a table with a list of clash test matrix test results therefore in the table we have for example:

 

clash ID combined disciplineleft disciplineright discipline# of clashes
001_clash AR VS ARARAR100
002_clash AR VS DRARDR25
...............
052_clash ST VS DRSTDR0
...............



we have 9 disciplines in total
AR , ID, ST, ME, WS, DR, FF, EL, LA
so the rest of our table will be a combination of any two and each discipline can be either on the right or left.

 

Currently, I have two slicers to filter the left group, and the second to filter the right group.

kha_powerbi_0-1676376600281.png

However, I want the slicer to work regardless of whether its on the right or left.

For example:
slicer 1= DR slicer 2= AR
The output of Left & Right slicers: (empty since clash has AR left and DR Right opposite to the current filter)

clash ID combined disciplineleft disciplineright discipline# of clashes
     


Desired output in the table

clash ID combined disciplineleft disciplineright discipline# of clashes
002_clash AR VS DRARDR25

 

2 REPLIES 2
miTutorials
Super User
Super User

yes this works for one slicer but if I add another slicer it wont work to filter out the rows with the same discipline ( eg: AR|AR) but insted it will give all values with AR in them. this does work however for different disciples with two slicers (eg: AR|DR). Is there a way to make it filter out the same discipline group?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.