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.

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

      powerbidevelope ,

       

      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