Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert data lay out

Good day all, I have the following question.   Below is table_1.   I want to convert that table in the lay out of table_2.   Is there any option in Power BI to do so?   Thanks for your kind a...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Please download the demo from the attachment. You can click or double-click the "Applied steps" to see the details. BTW, this may not be a good idea. What if there are thousands of Modes?

    =[Attribute] & " " & Text.From([Mode])

    Convert-data-lay-out

     

    Best Regards,
    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

Please download the demo from the attachment. You can click or double-click the "Applied steps" to see the details. BTW, this may not be a good idea. What if there are thousands of Modes?

=[Attribute] & " " & Text.From([Mode])

Convert-data-lay-out

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Good day!

    Thanks for the reply, works dine for me.

    John