Changing the name of a date bin

[erin_a]

Hi there,

I have binned my data so that I can report totals for 6-month periods. My question is whether it's possible to change the name of the bin values, for example from 'January 2018' (see table below) to 'January - June 2018', so that axis labels on visualisations are labelled with the full six month period rather than just the first month in the period?

Thanks in advance,

Erin

[erin_a]

Thanks @ryan_mayu! Once I created a custom sort order for the new column values this solved my problem with labelling. Appreciate your help. 😊

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@erin_a 

you can create a column

Column = 
VAR _min=minx(FILTER('Table','Table'[Date (bins)]=EARLIER('Table'[Date (bins)])),'Table'[Date])
VAR _max=maxx(FILTER('Table','Table'[Date (bins)]=EARLIER('Table'[Date (bins)])),'Table'[Date])
return FORMAT(_min,"mmmm")&"-"&FORMAT(_max,"mmmm")&" "&year(_min)

you can don't use the bin and create the column directly

Column 2 = if(month('Table'[Date])<7,"Janauary-June"&year('Table'[Date]),"July-December"&year('Table'[Date]))