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