Forum Discussion
Sorting Visual Card in a Different Order instead of Default
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
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!!
1 Reply
- Kishore_KVN
Solution Sage
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!!