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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jdb9294
Frequent Visitor

Slicer to filter based on several columns

Is it possible to have a slicer to only show rows where at least one column shows the selected data?

 

Example:

 I have a table with two columns CreatedID and ClosedID.

 

I want to be able to check off an ID in a slicer then have my visuals only show data where that ID exists in either column.

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@jdb9294

 

How about unpivoting the 2 columns using Query Editor.

Then you can create a slicer from that single unpivoted column which contains both Created and Closed IDs


Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

@jdb9294

 

How about unpivoting the 2 columns using Query Editor.

Then you can create a slicer from that single unpivoted column which contains both Created and Closed IDs


Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.