Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two tables as below
table1
PK1 | PK2 | name | states | age |
a | b | AM | arizona | 5 |
a | b | AM | cali | 5 |
a | b | AM | ny | 5 |
a | b | AM | nj | 5 |
a | b | AM | wy | 5 |
table2
PK1 | salary |
a | 201 |
I need to join those two tables on PK1 and create output as below
Currently i have started using matrix visualization and was able to get the below table. I couldnt get the 'states' column in the second last position as then it populates the column 'age' on all rows.
Is there any way i could achieve the result that I want and then join to table2 above to get the salary column?? Do i need to change the structure of my table1? it is manually created. While the second table is a calculation.
Solved! Go to Solution.
Hi @Anonymous ,
This is the forum of power bi, so I realized it in power bi. Please refer to pbix file:https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Eb0R0V6MLqRCpjQCRrKqLuYBvgsGsPTE7uE5zc0ocYSCog?e=Mz3pNc
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@Anonymous , You can join on PK1 one column. But you can not get the format in the first image. Check if there is some custom visual
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
Do you think that the below view is possible? I am not sure how to perform the join as in the first table PK1 occurs multiple times but in the second table PK1 would be there only for 1 time. I dont want to repeat the salary multiple times.
Hi @Anonymous ,
Is the screenshot below you want?
Just close the stepped layout and icon of row header and put states in the last filed of row:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Please share your workbook...thanks
Hi @Anonymous ,
This is the forum of power bi, so I realized it in power bi. Please refer to pbix file:https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Eb0R0V6MLqRCpjQCRrKqLuYBvgsGsPTE7uE5zc0ocYSCog?e=Mz3pNc
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
also, any idea what keywords I should search for to find a custom visualization?
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 |
---|---|
109 | |
101 | |
84 | |
79 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |