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 ease of use, I would like to create two name slicers that consist of the name set of individual names and sync them into one.  However, when I tried to do it, the single slicer is not giving me the right counts, it seems that there's a hierarchy given to one of the name fields.  

 

The name fields are "ACTION SOLICITOR NAME" and "PROSMGR SOLICITOR NAME."  

Since the two name fields are on the same master list, when I click on the individual name field slicer, it affects all of the visuals too.  Is there a way to make one slicer for the names and then have the names display the visuals according to what the individual slicer intends to?  

 

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.

2 Replies

  • 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.

  • Deevo_'s avatar
    Deevo_
    Resolver I
    2 years ago

    Hi there, This post is very helpful.

    • I have modified this slicer formula to suit my own requirements and include a second column when creating the "Slicer".

    Example: 

    Slicer =
    DISTINCT(
            UNION(SUMMARIZE('Teams', 'Teams'[Division], 'Teams'[Branch]),SUMMARIZE('Project_Codes', 'Project_Codes'[Division], 'Project_Codes'[Branch]))
                )
    • How can i modify the "Measure" to allow the user to select the field [Division] and/or [Branch] from the page slicer??

    Current measure that only works for [Division]:

    Measure =
    IF (
        OR (
            SELECTEDVALUE ( 'Slicer'[Division] ) = SELECTEDVALUE ( 'Teams'[Division] ),
            SELECTEDVALUE ( 'Slicer'[Division] ) = SELECTEDVALUE ( 'Project_Codes'[Division] )
        ),
        1,
        0
    )

     

    Many thanks!