Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I have bellow tables on PowerBI desktop, I want to relate the Account table to the event table without passing by the Opportunity table (the account in the event isn't the same as in the opportunity). The Account is very large so I don't want to duplicate it.
I would like also to relate the case table to the Event table, the relation is 1:Case -> n: Event.
What is the best way to model that on powerbi desktop.
@SniperPro , If want an opportunity as a dimension, then you can directly connect it . And remove join
then you can use this method to filter measure and slicer of opportunity
How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8
Other wise , two copies of opportunity - one as fact and another as dimension
@amitchandak
Thank you for you reply.
How can I modify the Control Measure to filter slicer in both way ? In your example I want to use the same Contol City Measure to filter the Cities when I chose a Customer.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
85 | |
79 | |
53 | |
39 | |
36 |
User | Count |
---|---|
100 | |
85 | |
47 | |
46 | |
44 |