Forum Discussion
Dynamic text boxes in power BI
| 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.
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.
step1step2get the table after unpivot columns
Finally, create a table visual to display your result as follows.
Best Regards,
Angelia
2 Replies
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
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.
step1step2get the table after unpivot columns
Finally, create a table visual to display your result as follows.
Best Regards,
Angelia
