Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server Developer Center >
> 
> 
PowerPivot for Excel 2013 - Losing formatting with date hierarchy

Unanswered PowerPivot for Excel 2013 - Losing formatting with date hierarchy

  • Monday, March 18, 2013 5:01 PM
     
     
    Sign In to Vote
    0

    Hi,

    I have a PowerPivot against a SQL Server 2012 DB and have a date table linked to a fact table.  When I create a Fiscal Calendar hierarchy made up of Fiscal Year and Fiscal Period and add that to my Power Pivot Design, it causes the pivot table to lose formatting.

    When I add Fiscal Year and Fiscal Period independantly, the formatting is maintained.

    Has anyone else seen this in Excel 2013 and is there any patch available?

    Thanks,

    Todd


    • Edited by Todd Fields Monday, March 18, 2013 5:01 PM
    •