Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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!
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
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?
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |