Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Hide future month from my graph

One would think this is not that hard but still I am having a hard time. This is the case : I already build a current period filter like : Current Period Filter = IF(     MAX(dimDate[Date...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, rpinxt 

Thank you very much for your reply. I did a diagram and it originally looked like this:

I did this by putting the year of the hierarchy in the page filter, as shown in the image below:

 

 

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
2 years ago

Thanks Anonymous but this is also not the solution.

 

This is the case :

 

So all periods without data in 2023 should stay.

(ie 04-2023, 06-2023 etc)

 

Yes that will work when I switch off 2024 but as you see 01-2024 has data.

And later also other periods in 2024 will have data.

 

Actually it is like this. We are now in period 03-2024.

All periods after that should not show.

But this has to be dynamic because next month 04-2024 should show and all others should not.