Forum Discussion
MULTIPLE CARD
- 3 months ago
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).
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