Forum Discussion

ROYMMM's avatar
ROYMMM
Icon for Advocate II rankAdvocate II
6 years ago

Hide future months in matrix

Hi,   I have a report with a matrix showing the availability of services. Every column represents a list of availability percentages of the respective services for a specific month. The matrix shou...
Need Help
sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi ROYMMM,

 

I assume you have some sort of date table. In your date table, do you have a column for the first date of the month? If not, create it like this

LastDateOfMonth = endofmonth('Date table'[Date])


Then create a new column like this

IsFutureMonth = if(today()>LastDayOfMonth;1;0)


Now for you matrix visual, add IsFutureMonth to the filter pane, and set the filter to IsFutureMonth=0.

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    If this calculated column is used as.a filter less than 0, it doesn't show anything. If it's equal to 0, it shows only the current month. If it's greater than 0, it shows all months, including future ones.

     

    I have tried your "solution" on two matrices, with and without YOY columns, and the result is the same.