Forum Discussion

smmcqueen's avatar
smmcqueen
Frequent Visitor
1 year ago
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...
Need Help
  • smmcqueen's avatar
    smmcqueen
    1 year ago

    I found the solution. If you right-click the row, there is an option to exclude. 

SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

Hi smmcqueen 

Have you tried modifying your measures to return blank for future dates?

Hidden Expense YTD =

IF(
 MIN(datetable[date]) > Today(), BLANK(), [Your calculation])

Do this for all the measures, any rows that are completely Blank will be hidden by Power BI.

 

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")


Hope this helps!

smmcqueen's avatar
smmcqueen
Frequent Visitor
1 year ago

Thank you for the prompt response! I will try that and let you know if it works. Thank you!

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    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.