Dynamic text boxes in power BI

[104731]

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.

[v-huizhn-msft · Accepted 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.

step1step2get the table after unpivot columns
Finally, create a table visual to display your result as follows.



Best Regards,
Angelia

[Anonymous]

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