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.
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!
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 |
---|---|
102 | |
101 | |
78 | |
70 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |