Forum Discussion

LeopoldStotch's avatar
LeopoldStotch
New Member
9 years ago
Solved

Filtering Different Data Sets with a Single Slicer

Hi,   I have a report with a single dashboard incorporating visuals drawing from three different data sets.   Each of the data sets has a field/column "Department" with the same four options for ...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi,

     

    you should create an extra table, just containing 1 column "Department".

     

    Then create the following relations:

    Department --> Dataset1.Department

    Department --> Dataset2.Department

    Department --> Dateset3.Department

     

    Use the Department from the new table as the Filter.

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

 

you should create an extra table, just containing 1 column "Department".

 

Then create the following relations:

Department --> Dataset1.Department

Department --> Dataset2.Department

Department --> Dateset3.Department

 

Use the Department from the new table as the Filter.

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

its not possible to have multiple connections to one table with Power Query btw