locked
[Issue] PIvotChat >Moving Avg on PowerPivot RRS feed

  • Question

  • Hello,

    In PowerPivot: exist 2 fact tab - Factfree & FactPaid. They share the same DimDate tab, join with dateKey.

    I create a slicer by using the dateKey column in DimDate tab. Create 2 separate charts(directly) for each of them.The charts look fine. I add moving avg on both charts. They are OK.

    the issue appears while I select the shared slicer, factFree have record for 2013+2014, FactPaid only has 2014.

    If I select 2013, the chart of FactPaid disappeared. It's by design. I understand - no data at all.

    But when I select 2014, both charts show up. but the moving avg line of FactPaid is permanently gone.

    Conclusion: Seems like if the shared slicer touch the black hole of join, the moving avg line will be removed forcedly by excel.

    Bob

    Monday, April 21, 2014 10:47 PM

Answers

All replies

  • Hi Bob,

    Could you share that file (or a copy without sensitive data) so that we can take a look? If not, how is that measure defined? Does it still show in the field list of the pivot table or will it actually be removed from the table? Are you able to add it back without any error?

    Regards,

    Julian

    Tuesday, April 22, 2014 5:59 AM
  • seems that this issue is related to Excel and not specifically to Power Pivot

    Once you select a period without any values the trendlines get removed 
    but switching back to a period with values does not add these trendlines again

    a workaround would be to create the Moving Average as DAX calculation as described here:
    http://www.powerpivotpro.com/2011/03/advanced-dax-calculation-doing-a-moving-grouped-average-in-powerpivot/

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    • Proposed as answer by Michael Amadi Wednesday, April 23, 2014 7:56 AM
    • Marked as answer by Elvis Long Monday, May 5, 2014 6:47 AM
    Tuesday, April 22, 2014 12:05 PM
    Answerer