Forum Discussion
table data presentation
Hi All, I have a table table1. but i want that table to be shown in my report tab like it is in the below format (right table) in PowerBI using a visual or power query or anything else . can this ha...
HI Anonymous
If so, you need to duplicate the basic data and transform it in duplicate table.
Then create the relationship by Name
Result:
and here is sample pbix file, please try it.
Regards,
Lin
parry2k thankyou so much for your help. but I need to show both the tables (showing the same data but just in different format) in my report tab. so can i achieve this in dax or some other way so that i can show both the tables visuals through one data table only.
.
Regards,
Chahat
v-lili6-msft
Community Support
Community SupportHI Anonymous
If so, you need to duplicate the basic data and transform it in duplicate table.
Then create the relationship by Name
Result:
and here is sample pbix file, please try it.
Regards,
Lin