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 ?  ...
Need Help
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