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.
Property Name | Location | Property Type | Year Built | Size RSF | Leased Percentage | Acquisition Date | Owner | Property Management Company | Leasing Company |
2020 K Street FINAL | NULL | NULL | NULL | 399726 | 0.672303028 | NULL | NULL | NULL | NULL |
I want the output as below
I want the data above populated as the image here. any help would be greatly appreciated.
Solved! Go to Solution.
Hi @104731,
I try to reproduce your scenario and get expected result.
1. I create the following sample table based on your screenshot.
2. Right click table->Quey Edit, select all columns in the table->unpivot columns->Apply&Close, you will get the following table.
Finally, create a table visual to display your result as follows.
Best Regards,
Angelia
Hi @104731,
I try to reproduce your scenario and get expected result.
1. I create the following sample table based on your screenshot.
2. Right click table->Quey Edit, select all columns in the table->unpivot columns->Apply&Close, you will get the following table.
Finally, create a table visual to display your result as follows.
Best Regards,
Angelia
Hi @104731,
I think you can use the "matrix" visual for your problem.
(documentation)
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/
Regards,
L.Meijdam
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |