Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Columns with text and date - sort for visualization

I have following column in table which is text data type. I need to sort this table in chronological order for date and word in certian orders. Also it need to apply for all fuutre date which will be...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    AUDISU Thank you very much for your prompt reply.

     

    Here are some other thoughts I'd like to share.

     

    I noticed that your screenshot uses the SUMMARIZE and UNION functions to create a new table.


    In fact, when you create a visual with that data, power bi can help you sort it automatically. Or you can sort manually.

     

     

    You can click on the field to select ascending or descending order.

     

     

     

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

AUDISU Thank you very much for your prompt reply.

 

Here are some other thoughts I'd like to share.

 

I noticed that your screenshot uses the SUMMARIZE and UNION functions to create a new table.


In fact, when you create a visual with that data, power bi can help you sort it automatically. Or you can sort manually.

 

 

You can click on the field to select ascending or descending order.

 

 

 

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.