Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I have question, can we connect the data betweet two column without using relationship.
I have table REVENUE and PBT but I cannot create the relation betwwen this two table because of the duplication data.
But its connect to Company name on Company Table.
I want to combined this two table data in one dashboard and using Date filter by revenue data.
Now when i select the data filter, the PBT data connot filter by that because data filter is from Revenue Data.
How can I connect the REVENUE and PBT because the date data is same but its duplicate.
Thanks
Solved! Go to Solution.
Not sure how was your data structure. Did you try to create the following relationship? Linked the date from PBT/Revenue to Calendar table. The calendar table contains unique date information so it can be used as a bridge to create relationship between PBT and Revenue.
@Kamaizziati,
Change cross filter direction of your relationships from Both to Single, then check if you get expected result as Jessica_Seiya descibed.
Regards,
Lydia
Do you want to filter data based on date? If this is the case, try to create a specific calendar table and then link it with the REVENUE and PBT tables. Then use the date info from calendar table for flitering.
Hope it helps
@Anonymous,
I already do like your suggestion but I cannot connect relation to both PBT and REVENUE due to the PBT and REVENUE already connect to COMPANY table.
Thanks
Not sure how was your data structure. Did you try to create the following relationship? Linked the date from PBT/Revenue to Calendar table. The calendar table contains unique date information so it can be used as a bridge to create relationship between PBT and Revenue.
Hi @Anonymous,
How do yo do that because I cant.
See below figure.
Thanks
@Kamaizziati,
Change cross filter direction of your relationships from Both to Single, then check if you get expected result as Jessica_Seiya descibed.
Regards,
Lydia
Hi @Anonymous,
How do yo do that because I cant.
See below figure.
Thanks
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
103 | |
103 | |
87 | |
61 |
User | Count |
---|---|
168 | |
138 | |
134 | |
102 | |
86 |