Forum Discussion
Charting Aggregated Monthly Data in Designer
I am not sure if I understand exact your issue..Because you use actual dates & are too many the axis is continuous ( in PowerView you can choose between continuous or categorical which shows the exact values)..If sorting is your problem I usually create 2 calculated columns in the date dimention table 1. year/ month " 2015 Jul " =YEAR(Date[date]) & LEFT(Date[MonthName)
2. a column to sort like "201507 " = (Year(date[date])*100 ) + MONTH(Date[Date])
Then choose the year/month calculated column & from the ribbon sort it by the sort column.
If your problem is the Visuals (not enough space to display ) follow andre suggestions..
Best solution I've found is to create a column EOMONTH([Dates],0) and use that on the axis.
But for some reason the line chart shows everything one month ahead so 5/31/2015 shows as June, etc.
So I use EOMONTH([Dates],0) - 31
That seems to work. Very hackish, but it works.
Please tell me there is a better way?
I am not sure if I understand exact your issue..Because you use actual dates & are too many the axis is continuous ( in PowerView you can choose between continuous or categorical which shows the exact values)..If sorting is your problem I usually create 2 calculated columns in the date dimention table 1. year/ month " 2015 Jul " =YEAR(Date[date]) & LEFT(Date[MonthName)
2. a column to sort like "201507 " = (Year(date[date])*100 ) + MONTH(Date[Date])
Then choose the year/month calculated column & from the ribbon sort it by the sort column.
If your problem is the Visuals (not enough space to display ) follow andre suggestions..