Forum Discussion

cinsbox's avatar
cinsbox
Frequent Visitor
3 years ago
Solved

Create two slicers from two different name fields then sync them into one slicer

Hi I am working off a "master data list" which consists of merges of several data lists to create a Dashboard.  I have two name fields in the master list which are used to filter the visuals.  For ea...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, cinsbox 

     

    You can try the following methods.
    Sample data:

    Create a table with only Name as a slicer.

    Slicer = UNION(VALUES('Table'[ACTION SOLICITOR NAME]),VALUES('Table'[PROSMGR SOLICITOR NAME]))

    Measure =
IF (
    OR (
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[ACTION SOLICITOR NAME] ),
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[PROSMGR SOLICITOR NAME] )
    ),
    1,
    0
)

    Hope this method helps you.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, cinsbox 

 

You can try the following methods.
Sample data:

Create a table with only Name as a slicer.

Slicer = UNION(VALUES('Table'[ACTION SOLICITOR NAME]),VALUES('Table'[PROSMGR SOLICITOR NAME]))

Measure =
IF (
    OR (
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[ACTION SOLICITOR NAME] ),
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[PROSMGR SOLICITOR NAME] )
    ),
    1,
    0
)

Hope this method helps you.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.