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

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Well, the problem I got stuck to in referencing the columnnames rather than the values in those columns. I was thinking something allong the lines of using UNION() and SELECTEDCOLUMNS() to create a new table but because you also want to keep the original columns it isn't really an unpivot action. 

Few questions: are the column names static or do you want this to be dynamic? Can you change the source? Do you want this to be done in power query or in DAX?

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Kudo's are welcome 🙂