Forum Discussion

tilvit1130's avatar
tilvit1130
Regular Visitor
4 years ago
Solved

Multi row cards - appears in single row

Hi I have created a table using existing columns for my project, it has restaurant id and cuisines, multiple cuisines are there in a raw, when i use multi raw card cuisines are shown as single raw, ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi tilvit1130 

     

    I would suggest that you split the Cuisines column by comma into Rows and trim the result column in Power Query editor. After that, apply the change and drag the new Cuisines column into the multiple-row card. You will have them in multiple rows then. 

     

    I do this in a new table, so I create a relationship (many-to-one) between it and original table on Restaurant ID column. See the attachment. 

    Result:

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi tilvit1130 

 

I would suggest that you split the Cuisines column by comma into Rows and trim the result column in Power Query editor. After that, apply the change and drag the new Cuisines column into the multiple-row card. You will have them in multiple rows then. 

 

I do this in a new table, so I create a relationship (many-to-one) between it and original table on Restaurant ID column. See the attachment. 

Result:

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.