Forum Discussion
Create Form in PowerBi
- Anonymous1 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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
- rosamhernandez11 year agoHelper I
Thank you, I believe this is the solution! I have a few questions, and will message you directly to not belabor the topic here.