Forum Discussion
MULTIPLE CARD
Hi everyone, I have a question about several cards. Does anyone know how I can sort them by value? I only see them sorted alphabetically. Is there an alternative?
I would recommend using a Table or Matrix visual instead, since those visuals support sorting by values. As far as I know, native Card visuals in Microsoft Power BI Desktop do not support dynamic sorting by value and are generally displayed in the order the fields are added (or alphabetically in some cases).
5 Replies
Ammmetthh this is an issue many of us want to be resolved soon. Right now there is no option.
In a previous post MasonMA posted:Consider submitting a new idea- https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
For the moment, the classic multi-row card would still be a better choice.
And someone just posted it:Sort By / Sort Order New Card Visual - Microsoft Fabric CommunityI would recommend using a Table or Matrix visual instead, since those visuals support sorting by values. As far as I know, native Card visuals in Microsoft Power BI Desktop do not support dynamic sorting by value and are generally displayed in the order the fields are added (or alphabetically in some cases).
Hi Ammmetthh ,
Thank you Ilgar_Zarbali for the response provided!
Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Thank you.Solution:
There are two possible approaches for sorting by measure values:
Approach1:
Matrix Visual with DAX Ranking :
As an alternative, we can use a Matrix visual with a DAX ranking function such as
STEP1: create this below measure
RANKX(
ALL(Table[Category]),[Measure],
DESC
)
STEP2:
then be formatted to look like a card visual like:
• Removing headers and gridlines
• Increasing font size
• Adding background and spacing
Approach2:
Use Advance card visual:
STEP1: Go to visualization then get more visuals
STEP2: search Advance Card then install it
This visual lets you sort them by values
