Forum Discussion
Helper IIIDate 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 there a way to prevent that? Or since it's a hierarchy, does Power BI have to take into account every month within the higher structure levels (year, quarter)?
11 Replies
- Phil_Seamark
Microsoft Employee
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.
nsadams87xxThanks 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
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?
