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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
bergen288
Helper IV
Helper IV

how to create a slicer with values from multiple columns?

Below is an example of my table visual with Name1, Name2, Name3 columns.  I would like to create a slicer with values from all 3 columns so that I can select particular name such as "C" no matter which column has it.  That is, the target slicer value "C" should select 1,3,4,7,8 rows.  How to do it?

bergen288_0-1680553579455.png

 

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

you need to create a new table

Screen Capture #799.png

View solution in original post

2 REPLIES 2
bergen288
Helper IV
Helper IV

Here is how to make it work, partially.  Below is my DAX to create new slicertable: 

SlicerTable =
DISTINCT (
    UNION (
        VALUES ( Table1[Name1] ),
        VALUES ( Table1[Name2] ),
        VALUES ( Table1[Name3] )
    )
)
Next is a measure:
Name =
IF (
    SELECTEDVALUE( 'Table1'[Name1] ) IN VALUES ( SlicerTable[Key] )
        || SELECTEDVALUE( 'Table1'[Name2] ) IN VALUES ( SlicerTable[Key] )
        || SELECTEDVALUE( 'Table1'[Name3] ) IN VALUES ( SlicerTable[Key] ),
    SELECTEDVALUE(SlicerTable[Key]),
    BLANK ()
)
 The last step is to create slicer by slicertable[Name], and add 'Name' mesure into target table visual.  It gives me correct answer when "C" is selected.
bergen288_1-1680636228048.png

However, it gives me nothing when "All" is selected or nothing is selected.  My 'Name' measure is copied and modified from someone.  I believe the BLANK function is the root cause.  How to fix it?

bergen288_2-1680636313403.png

 

 


 

 
 
Ahmedx
Super User
Super User

you need to create a new table

Screen Capture #799.png

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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