Forum Discussion

suvechha's avatar
suvechha
Helper IV
4 years ago

Sort by Day Month ?

Hi there,

 

I have data like below , but in my chart I do only have Day Month to show not Date .My requirement is show data from 02/11 until 02/10 i.e one month data. How to sort the Day Month ?

 

 

 

because when sorting by Day Month , I am getting the result like below - its showing 31/12 which is of last year 

Need Help

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    4 years ago

    HI suvechha 

     

    You want to show 1 month's data but your table has more than 1 month's worth of data?

     

    I'm not clear on what data you have.  Are you saying you don't have dates in your table, only Day/Month?  Where did the dates in the table visual come from?  Do you have a Date Table?  How did you get the Date/Month?

     

    If you do have dates in your table, add a slicer, set to Between, to only show the data you want.  Then sort by date.

     

    Regards

     

    Phil

     

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi suvechha 

     

    Can you try select the checkbox of time intelligence.

     

    After that, you can use Date Hierarchy. It is very clearly show the date.

    OR

    You can try to transform Day Month to date type.

     

    IF I misunderstood what you mean , please share the pbix file without any sensitive data and expect result.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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