Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago
Go to power query editor - - > select Name column - - > go to transform tab - - > unpivot column.

After that in above name column append "fd" at the end of the text.

Please give Kudos and accept this as a solution if it helps you.