Sort by Day Month ?

[suvechha]

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 

[v-chenwuz-msft]

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.

[PhilipTreacy]

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