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

Hi nsadams87xx

 

You could add report, page or visual level filters to filter out the dates you don't want.  Or add a slicer to your page.  Finally you can add DAX code to your measures to only return data for relevant date ranges. 

  • 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.