Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
3 years ago

Sorting visual by a "date" that is text based.

Hi all,   I have a line graph visual that shows data by month/year; however, the the data is a text field and the data is "11 2022 Name", "12 2022 Name", "01 2023 Name", "02 2023 Name", and so on. ...
Need Help
rohit_singh's avatar
rohit_singh
Icon for Solution Sage rankSolution Sage
3 years ago

Hi PowerBINoob24 ,

In DAX, you can create a new column named "DateIndex" as shown below :

 

Then select the Date column, click on "Sort by column" and select DateIndex.

 

Kind regards,

Rohit


Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    3 years ago

    rohit_singh 

    Don't you get a circular dependency from that?

    • rohit_singh's avatar
      rohit_singh
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Hi jdbuchanan71 ,

      Thanks for pointing that out. I should have checked before posting. The Power query approach is the correct one. 
       
      Kind regards,

      Rohit

Related content