Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Creat more than one relationship

Hello,   I have created relationships between 3 sheets using a date table (green).   The 3 sheets also have similar data in the column BZ_20, BZ_21, BZ_Soll (yellow) which is the number of the Bu...
Need Help
  • PC2790's avatar
    PC2790
    5 years ago

    Power Query --> Append Queries--> Append as new(it will constitute of the all the columns from your other tables)

    In the transformation steps, remove all the columns those are not required -->Remove duplicates and your table is ready to be used as slicer.

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
5 years ago

Hello Anonymous ,

 

Try creating a new table with all the unique values of Business Unit.

You can do that in Power Query by appending this column from all tables.

Then use the business unit as a slicer/filter from the newly created table for your requirement.

 

Thanks

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hallo PC2790,

 

I created a new table: Power Query --> new Query --> combine --> combine and add as new Query (marked the BZ columns from each table that I want to filter in the graphic)

 

Then I used the BZ-column of the new created table as slicer but it does not affect the graphic.

 

Is there something I missed? 

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Power Query --> Append Queries--> Append as new(it will constitute of the all the columns from your other tables)

    In the transformation steps, remove all the columns those are not required -->Remove duplicates and your table is ready to be used as slicer.