I am trying to get my line chart to show the date as something like 'Jan 2018'. If I create a pivot table, I can get this representation by simply putting the formatting in the formula like: Date(MonthStart(DateOfEvent), 'MMM YYYY')
For some reason when I put this in the line chart it renders as m/d/yyyy. I suspect there a feature that is overriding my formatting but I am not sure where that setting can be changed. Ideally I would like to change the formatting at the object level and not the application level. Any help would be greatly appreciated! Thanks
Re: Format Date Dimension 'MMM YYYY' (QS April 18)
I tried using:
Month("DateOfEvent")&'-'& Year("DateOfEvent") AS MonthYear
but that kills my sorting so I was considering loading:
Dual(Date(MonthStart(DateOfEvent), 'MMM YYYY'), Month("DateOfEvent")&'-'& Year("DateOfEvent") AS MonthYearDual
The hope is that I can use the text for the visualization and the number for the sort. I am resorting to the classic trial end error method. I thought that I should be able to use MonthYear in the visualization and just override the sort with a custom expression but for some reason when I apply a filter it scrambles the sort order. This seems like it should be a quick fix but it is turning out to be rather time consuming...