Sorting Visual Card in a Different Order instead of Default

[arikofather]

In this simple report, I would wish that the filter card be sorted from 1 to 7.

Instead of:

I tride using Sort Order table but it did not work.

Desired Result:

PBIX:   Deal Stage Filter.pbix

Data:  data table.csv

[Kishore_KVN · Accepted solution]

Hi arikofather,

Here is the solution for the issue.

The DAX function which you are using to generate the card visual is missing order expression. I included the order expression. Check the DAX below

Deal Stages Selected = 
CONCATENATE(CONCATENATE(
"Deal Stage selection : ",
CONCATENATEX(ALLSELECTED('Data Table'[Deal Stage]),'Data Table'[Deal Stage], "  ", 'Data Table'[Deal Stage]))," ")

The result looks like

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!