How to get rid of row context in below scenario

[AnandNamburi]

Hi All,

I have a date column which is in the format "Date/Time(General Format) and I have converted it to "Custom Format" like (mmm-yy).

When I drag and drop the date column it was displaying Jan-19 or other values by datewise(taking row context), I need it like when I drag and drop it should display jan-19,feb-19,mar-19 like wise.

Thanks,

Anand

[negi007]

@AnandNamburi in this case, you need to sort the data in your table. that will ensure that your order is same everywhere. see below screenshot on how to sort by column

[AnandNamburi]

I have sorted it as you said but in filters it is not working as expected. See screenshots below.

[negi007]

@AnandNamburi can you please share some example or screenshot of your expected output to help you on this.

[AnandNamburi]

Sure.

[CNENFRNL]

Underlying data of this column remains the same as DateTime if you only change its format instead of recalculating the values.

[negi007 · Accepted solution]

@AnandNamburi ok. since you are changing only the format of the order date, it is showing only month and year. in this case, i would suggest you to add another column in your table like below

Month_Year = FORMAT('Calendar'[Date],"MMM-YY")

and then use this column in your visual. this will aggreate data at month and year level.

hope this is what you want here. thanks

[AnandNamburi]

It worked Thanks. But when I'm dipsplaying the newly created column it is of data type text and it is storing from "A-Z".

Is there any that that I can sort it like earliest month and eraliest year.

Like Jan-21, Feb-21, Mar-21 e.t.c 

Thanks,

Anand

[negi007]

@AnandNamburi you can sort you table by month. in the below link you can find solution

https://community.powerbi.com/t5/Desktop/sorting-a-date-table-chronologically/td-p/280635

[AnandNamburi]

@negi007 this works good in a visualization as I can sort the data on required column. But when I kept the column Month Year in filters it is behaving same. In filter sort options we have AtoZ or ZtoA, no option to select any column specifically. Do we have any workaround for this.