Forum Discussion

thedon16's avatar
thedon16
New Member
11 years ago
Solved

Charting Aggregated Monthly Data in Designer

I have transactional data with sales dates and sales amounts that I want to plot in a line chart with sum of sales for each month.   This seems surprisingly difficult to get charted and sorted in t...
  • konstantinos's avatar
    konstantinos
    11 years ago

    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..

     

gsalas's avatar
gsalas
Advocate II
10 years ago

Hi! I am having the same issue.  I have 4 columns from four different tables I wish to display in a combo chart.  The data is daily but combined into weekly data points using links between the 4 different data tables and a single central date table with week ending dates in a secondary column.  When I try to plot the four data points (2 bars, 2 lines) the lines come out completely scrambled.  This is despite the fact that all data sources are sorted in ascending order.  I have to convert the week ending dates to monthly, which I do not want to do.