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...
Need Help
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 

     

    thanks for your reploy, your expression is not working.

     

    Any help is appreciated..

     

    Thanks......

     

    • 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..

       

       

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

        powerbidevelope ,

         

        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.