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
I have 2 tables table1 and table2, i want to create a new table visaul as described below
The combination of type and car is unique for each rows.
Table1 | ||||
Unique Cobination--> | Type | Car | Count | Salesman |
Diesel | Dzire | 1 | Ram | |
Petrol | xl6 | 2 | Rajan | |
Hybrid | swift | 3 | Rita | |
Diesel | Thar | 3 | Rita | |
Petrol | Rapid | 2 | Ram | |
Hybrid | Thar | 1 | Rajan |
Table 2 | ||
Unique Chesis# | Car | Type |
1 | Dzire | Diesel |
2 | Thar | Diesel |
3 | Thar | Diesel |
4 | Thar | Diesel |
5 | xl6 | Petrol |
6 | xl6 | Petrol |
7 | Rapid | Petrol |
8 | Rapid | Petrol |
9 | swift | Hybrid |
10 | swift | Hybrid |
11 | swift | Hybrid |
12 | Thar | Hybrid
|
Desired table | |
Unique Chesis# | Salesman |
1 | Ram |
2 | Rita |
3 | Rita |
4 | Rita |
5 | Rajan |
6 | Rajan |
7 | Ram |
8 | Ram |
9 | Rita |
10 | Rita |
11 | Rita |
12 | Rajan |
Hey @Kapilchauhan555
Please follow the below steps to achieve the expected output
Step1: Create a calculated column in both table
Step2: Configure the relationship from table1 to table2 based on newly calculated columns
Step3: Plot the required columns
You will get the expected output.
If it works then please mark my solution as accepted and kudo the post so that others can find it quickly while facing a similar issue. Thank You!
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 |
---|---|
113 | |
106 | |
105 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
133 | |
93 | |
90 |