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..
I often see users struggling when they try to build all visuals based on one very wide table with a large number of columns in it.
One thing you might consider is breaking your data up in several tables, with one of them dedicated specifically for Date/Time.. In this scenario, you can add extra columns to that date table and also specify sorting order and aggregation attributes such as month/quarter/half year, year, fiscal year, etc.
This tutorial may be helpful in getting you started on how to organize your data so that it is easier to grow your model in the future and to have fewer issues with calcs and visuals.
