SSAS2008 r2 and Excel Line Chart and Date Axis


  • Hi

    Excel 2010. SSAS 2008 R2

    I have a excel line chart made out from SSAS pivot table with a date dimension (date) and No of licences.

    Currently, it displays 1/Jun/2014 to 30/Jun/2015 (FY2015) and this looks really ugly. 

    While keeping the details, I'd like to display by Month-Year. 

    However, while I can do this with other normal excel data, I just can not do it with SSAS Pivot table.

    Under Axis options, I ticked 'Date axis' but it won't bring up date options. 

    I think I tried everything but just can not figure it out. I wonder if it is even possible.

    Th date dimension is recognised as date because I can apply date filter.  I want to make it neat. Can anyone help me with this please? 

    It must be 'Date' Level. 

    Kind regards

    Friday, August 29, 2014 8:43 AM


All replies