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

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

        As mentined if you share your % calculation, it will help to understand what is going on and find out the solution. Thanks!