Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Using a basic table in Power BI, I want to provide row level data for a group of individuals (name, address, and phone number). However, my phone number table has a row for each phone number on file (e.g., cell and home). I am getting my data through a direct query. Below is an example of what I have and what I am trying to accomplish.
Current State
ID | Phone_Type | Phone_Numb |
1235890 | CELL | 012-345-6789 |
1235890 | Home | 987-654-3210 |
Desired State
ID | CELL | HOME |
1235890 | 012-345-6789 | 987-654-3210 |
Any thoughts on how this can be accomplished? Thank you for any suggestions.
Take care.
Solved! Go to Solution.
Use a matrix visual instead of a table visual and put ID on the rows and Phone_Type on columns.
Use a matrix visual instead of a table visual and put ID on the rows and Phone_Type on columns.