Forum Discussion

104731's avatar
104731
Frequent Visitor
8 years ago
Solved

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 399...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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