Forum Discussion

powerbidevelope's avatar
powerbidevelope
Frequent Visitor
7 years ago

Month and Quarter Incorrect sorting

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:

User Selection = CONCATENATEX(VALUES(Sheet1[CAL_MTH_NAME]),Sheet1[CAL_MTH_NAME],", ")&"
"&CONCATENATEX(VALUES(Sheet1[CAL_QTR]),Sheet1[CAL_QTR],", ")

 

Thanks

 

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    So normally you put in a "sort by" column and set your column to sort by that column. 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    powerbidevelope ,

     

    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.

      • powerbidevelope's avatar
        powerbidevelope
        Frequent Visitor
        7 years ago

        Hi v-yuta-msft v-yuta-msft 

         

        i am just thinking like as we do not have continuous dates, sorting is not working. Is that correct? or any other reasons..

         

        Thanks..