Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Today I wanted to bring three columns (fields) from three different tables in to Table Visual but I couldn't.
Three columns are:
1) CustomerName from "Customer" table
2) CustomerId from "Sales" table
3) Exposure from "Exposure" table
I can't understand why i couldn't do that.
1) Please can anyone explain why?
2) What should I do to get Sales table data and Exposure table data together in to TABLE visual, BASICALLY I DO NOT WANT TO USE CUSTOMER TABLE INFORMATION
3) To achieve POINT (2) how my data model should look like
PLEASE NOTE: I DO NOT WANT TO USE MANY-TO-MANY RELATION (BECAUSE TABULAR MODEL DOESNOT ACCEPT)
Here with the example:
Data Model:
Data:
Customer | Sales | Exposure |
Thank you
Solved! Go to Solution.
Hi @Anonymous
Create the relationship as below
Add columns in the table visual, select "sum" for "sales" and "exposure" column.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Create the relationship as below
Add columns in the table visual, select "sum" for "sales" and "exposure" column.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use the customer ID from the customer table, not the sales table
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |