Year/Month in bottom of visual

[bilingual]

Hi, i have made a visual which only shows last month, i would like to either have the present Year/Month in Title or in bottom below X-axis, anybody got an idea?

[bilingual]

Hi Amit, what i need is more simple, just like this Powerpoint, i need the present Month and Year below the diagram

[amitchandak]

@bilingual , One way it two use two columns x-axis month year and the other you have. Sort on these two columns. And concatenate label off and try

[bilingual]

Hi Amit, thanks i made it work, but when i remove the concatenate option, the sorting(high to low) is not correct.

[Anonymous · Accepted solution]

HI @bilingual,

You can refer to the following blog to create a custom sort table and link to raw table fields. Then you can use the new field to replace the raw field, it should show the custom sort index on your visuals:

Custom Sorting in Power BI  

Regards,

Xiaoxin Sheng

[amitchandak]

@bilingual , You can create measure like

Max month =

var _1 = maxx(allselected(Date), Date[Date])
return
maxx(filter(Date, Date[Date] =_1), Date[Month])

Max month -1 =
var _1 = eomonth(maxx(allselected(Date), Date[Date]) ,-1)
return
maxx(filter(Date, Date[Date] =_1), Date[Month])