Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Icon for Post Patron rankPost Patron
9 years ago
Solved

Combined slicer

Hello Guys, It is possible to combine two slicer into one? Data are in two different data sheets and there isn't relationship between data. I am visualizing data from two data sheet in one Page. C...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    AndrejZitnay,

     

    Hi Andrej,

     

    A slicer works on its parent table or works through the relationship. So we need to find out a way to establish relationships. Here we go:

    1. Create two new tables. 

    DateTable =
DISTINCT ( UNION ( VALUES ( Table1[Date] ), VALUES ( 'Table2'[Date] ) ) )
    NameTable =
DISTINCT ( UNION ( VALUES ( Table1[Name] ), VALUES ( Table2[Name] ) ) )

    2. Establish relationships.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    3. Create slicers with the column from new tables.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    AndrejZitnay,

     

    Hi Andrej,

     

    I am so glad to help. You can try to add a filter function like this. Add a "[" after "isblank(", then there will be a hint of column that can be selected.

    Date Table =
FILTER (
    DISTINCT (
        UNION ( VALUES ( Terminations[Date of Renewals] ), VALUES ( Renewals[Date] ) )
    ),
    ISBLANK ( [Date of Renewals] ) = FALSE ()
)

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

AndrejZitnay,

 

Hi Andrej,

 

I am so glad to help. You can try to add a filter function like this. Add a "[" after "isblank(", then there will be a hint of column that can be selected.

Date Table =
FILTER (
    DISTINCT (
        UNION ( VALUES ( Terminations[Date of Renewals] ), VALUES ( Renewals[Date] ) )
    ),
    ISBLANK ( [Date of Renewals] ) = FALSE ()
)

Best Regards!

Dale

AndrejZitnay's avatar
AndrejZitnay
Icon for Post Patron rankPost Patron
9 years ago

Hello Dale,

 

Thank you very much.

 

I had to change cross filter directions in  name table as it was fighting somehow with date table but I have now what I needed.

 

Have a great day.

 

Kind reagards.

 

Andrej