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, 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

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.

10 Replies

  • 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.

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    tilvit1130 

    You can create a measure follows and use it:

    NewMeasure = 

CONCATENATEX (
    'cuisines served',
    Restaurant[Cuisines],
    UNICHAR (10)
)
  • tilvit1130's avatar
    tilvit1130
    Regular Visitor
    4 years ago

    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's avatar
      Fowmy
      Super User
      4 years ago

      tilvit1130 

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