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.

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!