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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous file attached, look at table (4) steps, there are other tables in the model, just ignore those

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    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