Multi row cards - appears in single row

[tilvit1130]

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, i need to display as multiple rows, can someone help me pls.
table was created using below commands
cuisines served = SUMMARIZE(Restaurant, Restaurant[Restaurant ID],Restaurant[Cuisines])
When i use multi raw cards it appears as below, I need it to be as second screen where items are in multiple rows.

thanks in advance

[v-jingzhang · Accepted solution]

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.

[tilvit1130]

Hi Fowmy, THanks for your quick reply 

when i try to apply above to measure, Restaurant[Cuisines]  -> 'Cannot find name '[Cuisines]'

if i change to  

NewMeasure =

    CONCATENATEX (
    Restaurant,

    Restaurant[Cuisines],
    UNICHAR (10)

) 

i am getting the same results not giving in separate rows. screen shot attached

 thanks for the suppport. 

[Fowmy]

@tilvit1130 

Create a small Power BI file with dummy data and with your scenario and share it to check, explain the expected results clearly.

[Fowmy]

@tilvit1130 

You can create a measure follows and use it:

NewMeasure = 

CONCATENATEX (
    'cuisines served',
    Restaurant[Cuisines],
    UNICHAR (10)
)

    

[tilvit1130]

Dear Fowmy

please find a dummy from below link

https://drive.google.com/drive/folders/1helZBX_IFzWbhKyqUhxOJo74ybE8Rr1z?usp=sharing

Regards

Bary

[Fowmy]

@tilvit1130 

You can use a Card Visual to show line by line

[tilvit1130]

Dear Fowmy 

i try to create reference of the resturant table and getting below error any idea why i am getting this one pls. 

[tilvit1130]

Dear Fowmy

Used a card visual but didnt get the line by line,

rgds

bary

[tilvit1130]

Dear Fowmy

used card visual but did not show line by line

regards

bary

[tilvit1130]

Dear Fowmy

used card visual but did not show line by line

regards

bary