Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multi-Row Card Orientation of Values

Greetings everyone, I have used a multi row card. I want to change the orientation of the values of a multi row card so that the values appear in a horizontal fashion instead of vertical. What I ha...
Need Help
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    I don't think you can do that in multi-card visual.

    I suggest you use a matrix visual, something like below:

    Make sure to remove outlines from Colume Headers & Row Headers under formatting options for the visual.

     

    Thanks,

    Pragati

  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    You can create a calculated column something like below:

     
    CategoryWithDelim =
CONCATENATE(
ClothingSales[Category], " , "
)

    Just replace the column name in above DAX with your column name.

     

    Move this new column to matrix visual as did previously. You will get something like below:

    The only drawback of this solution is it adds a delimiter to the last value as well.

    You can play around with the DAX as well.

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

I don't think you can do that in multi-card visual.

I suggest you use a matrix visual, something like below:

Make sure to remove outlines from Colume Headers & Row Headers under formatting options for the visual.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi @Pragati11 , thanks for the fast answer. This is really close to what I wanted. If I would be able to add a delimiter between the values such as a comma or dot(as shown in the screenshot) then it would be really amazing. 

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous ,

       

      You can create a calculated column something like below:

       
      CategoryWithDelim =
CONCATENATE(
ClothingSales[Category], " , "
)

      Just replace the column name in above DAX with your column name.

       

      Move this new column to matrix visual as did previously. You will get something like below:

      The only drawback of this solution is it adds a delimiter to the last value as well.

      You can play around with the DAX as well.

       

      Thanks,

      Pragati