Create Form in PowerBi

[rosamhernandez1]

I need to recreate a document that looks the same as a Word document in Power Bi, the native looks like this:

Locational Information

Name	Data from table
Utility	Data from table
Shared Facility	Data from table
911 Address	Data from table
Fire Department and Phone Number	Data from table
GPS	Data from table
POI	Data from table

Operational Information

Operational Contact	Data from table
Maintenance Contact	Data from table
Nominal Size at POI	Data from table
Nominal Energy Duration	Data from table
Interconnect Capacity	Data from table
POI Charge Limit	Data from table
Co-located Charging	Data from table
NERC CIP	Data from table
Use Case(s)	Data from table
Dispatch Method	Data from table

I have added the table with the data for the right-side column into Power Bi already, but I don't know what type of visual will allow me to create the two columns with the left column static and the right to pull information from the table. 

[Anonymous · Accepted solution]

Hi @rosamhernandez1 ,
If you want static columns on the left side and dynamic columns on the right side, then I recommend using the Table Visual Object as well as the Matrix Visual Object. These two visual objects correspond to different scenarios for you to choose from.
For example, if you have a single piece of data with only one value per static column as shown in the image below:

Then I recommend that you use the table visual object, where we use the index column as a relational join between two tables to ensure that our output is dynamic.

However, if you have a large amount of data and each static column has more than one value, as shown in the figure below:

Then I suggest you use the matrix visual object, where we use the index column and the lable as a relational join of two tables with a one-to-many relationship to ensure that our output shows all results

If you have further questions you can check the pbix file I uploaded, I hope my method will help you solve your problem, I would be honored if I can solve your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[rosamhernandez1]

Thank you, I believe this is the solution! I have a few questions, and will message you directly to not belabor the topic here.