Forum Discussion

rosamhernandez1's avatar
1 year ago
Solved

Create Form in PowerBi

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 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.