Creat more than one relationship

[Anonymous]

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 Business Unit.

So when I visualize the sheets in one graphic I can filter by date but not by Business Unit. 

Since PowerBi wont allow more than one relationship, is there a workaround for that so I can also filter by Business Unit?

Thank you!

[Anonymous]

Hallo @PC2790,

now it works, thank you!

[v-xulin-mstf]

Hi @Anonymous

You can use USERELATIONSHIP function to apply more then one active relationship.

For more information, you refer the following blog.

https://blog.pragmaticworks.com/powerbi-dax-function-userelationship-explained

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[PC2790]

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]

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 · Accepted solution]

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.