Forum Discussion
Solved
Filter Out Future Quarters in Matrix Visual
I have report with a Calendar table and an Expenses table. I used the Calendar table to create Year-to-Date, Quarter-to-Date, and Year-over-Year change measures. The Calendar table contains future da...
I found the solution. If you right-click the row, there is an option to exclude.
Thank you for the prompt response! I will try that and let you know if it works. Thank you!
Alternatively you might be able to create a measure and apply a filter in the Filter pane, drag the measure in "Filters on this visual" then filter to Y.
Hide rows = IF(
MIN(datetable[date]) < Today(), "Y")
This would only need to be done once vs once for each measure.