Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
In Our report, we have to display the current User Selection(Slicer Selection) in a Card Visual
We have
1. Year Slicer(Single Select)
2. Quarter(Multi Select)
3. Month(Multi Select)
When we display the user selection, it is not coming in sorting order.
Please help..
pbix file:
https://github.com/bodempudi/CodeSnippets/blob/master/PowerBI/Demos/month%20sort%20issue.pbix
sample excel file:
https://github.com/bodempudi/CodeSnippets/blob/master/PowerBI/Demos/date%20sorting%20%20issue.xlsx
dax expresion:
Thanks
You can add two parameters [order_by_expression] and [order] in concatenatex() function like below:
User Selection = CONCATENATEX(VALUES(Sheet1[CAL_MTH_NAME]),Sheet1[CAL_MTH_NAME],", ", Sheet1[CAL_MTH_NAME], ASC)&" "&CONCATENATEX(VALUES(Sheet1[CAL_QTR]),Sheet1[CAL_QTR],", ", Sheet1[CAL_QTR], ASC)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yuta-msft
thanks for your reploy, your expression is not working.
Any help is appreciated..
Thanks......
i am just thinking like as we do not have continuous dates, sorting is not working. Is that correct? or any other reasons..
Thanks..
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
Yes, based on my test, concatenatex() will sort by the first charater of the text if the values are not date or number.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So normally you put in a "sort by" column and set your column to sort by that column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |