My visualisation is of the format MMMM-YYYY, i want it to be converted to MMM-YY.

[Anonymous]

I am creating a visualization where the availability is shown month-wise and in a sequence.

I am trying to modify it to MMM-YY, but it is coming in a text format and the graph sequence is disturbed

[parry2k · Accepted solution]

@Anonymous you have to add anotehr column to sort this colum 

Add Month Sort column using

Month Sort = FOMRAT ( Table[Date], "YYYY-MM" )

go to modelling tab, select your existing month column, and in sort by column drop down, choose Month Sort

[amitchandak · Accepted solution]

You can create a YYYYMM sort column and mark it as sort column.

Month Sort = format(date[date],"YYYYMM")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[parry2k · Accepted solution]

@Anonymous you have to add anotehr column to sort this colum 

Add Month Sort column using

Month Sort = FOMRAT ( Table[Date], "YYYY-MM" )

go to modelling tab, select your existing month column, and in sort by column drop down, choose Month Sort