Forum Discussion

nsadams87xx's avatar
nsadams87xx
Icon for Helper III rankHelper III
8 years ago

Date Hierarchy Displaying too much data

Hey Everyone,   I have a matrix that is showing a date hierarchy for previous budget vs actual data.  When I drill down to a month level, the matrix also shows months that haven't happened yet.  Is...
Need Help
nsadams87xx's avatar
nsadams87xx
Icon for Helper III rankHelper III
8 years ago

Thanks Phil.  I'm curious as to why the matrix goes into the future.  My data set dates in all of my tables stop 14 days prior to the current date.  So for today, I would have data up to Feb 5, 2018 (which is correct, our system that feeds the data in SQL has a lag time).  Shouldn't the March 2018 and beyond just not display at all?

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

The date table being used on the axis probably goes to the end of the year.   Do you have your own Date table or are you using the in-built auto date tables provided?

  • nsadams87xx's avatar
    nsadams87xx
    Icon for Helper III rankHelper III
    8 years ago

    If I think I know how to answer this, I'm using my own table with dates in it.  I'm using the built-in hierarchy capability on the axis.

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      % column in your report seems to be a calculated measure and wondering if that is what makig it show data in the future?

       

      Two things:

       

      1. Can you remove % column and check if it doesn't shows blank rows?

      2. if you remove % column and you are NOT seeing blank rows, share the measure you used for %

      • nsadams87xx's avatar
        nsadams87xx
        Icon for Helper III rankHelper III
        8 years ago

        Removing that column is showing the matrix correctly now.  What if I aggregated my data by a month level rather than at a date level?