Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 have is as belows:
How I want the result to look like:
Please suggest some solution or work around. Any visual(including custom visual) is okay as long as the result is achieved
Solved! Go to Solution.
Hi @Aditya_Meshram ,
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
Hi @Aditya_Meshram ,
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
Unfortunately, for now multi-row card visual does not provide an option to switch the orientation between Vertical and Horizontal. Please check this Microsoft Idea and upvote it and this way the product team may add this feature in the future.
Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!
Best regards,
Gonçalo Geraldes
Hi Gonçalo, thanks for showing me that idea, I upvoted it. Lets hope that this idea gets implemented. It would be really helpful to be able to adjust the orientation of values 👍
Hi @Aditya_Meshram ,
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
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.
Hi @Aditya_Meshram ,
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