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
WorkHard
Helper V
Helper V

Combine multiple values of a column into one for Slicer Visual

I have some category types for each record in the dataset.

These categories are represented in columns.

I need to create a slicer that can show each category and filter the records accordingly.

 

The issue is that one record can be in multiple categories. 

 

Sample data:

EmployeeCategory XCategory YCategory Z
John1  
Mike 1 
Joe  1
Chandler111

 

In the above example, my slicer will have three choices: Category X, Category Y, Category Z.

How can I add the 3 categories in one slicer and make it so that Chandler is available in all 3 categories?

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

@WorkHard ,

 

You need to unpivot the data, so you can work with all the categories.

Capture.PNG

 

Capture.PNG

 

Check the attached file.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

1 REPLY 1
camargos88
Community Champion
Community Champion

@WorkHard ,

 

You need to unpivot the data, so you can work with all the categories.

Capture.PNG

 

Capture.PNG

 

Check the attached file.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



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.