This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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?
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
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.
Hi @Ammmetthh ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
@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 Community
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).
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |