Forum Discussion
Filter date -> Keep values between selected dates
JMHenriques ,
That is what is expected. You are filtering on Contract Expiry Date field and hence it will filter out all data which is not having Contract Expiry Date betwen 2023 and 2027.
If you want forecasted values between 2023 and 2027, then you need to filter on Forecast Year.
Check this:
Hi Anand24 ,
That is what I made and it seems that it doesn't work that way. I've made a simple pbix 6 rows as an example -> pbix Example
As you can see in, in the filter I have what you said and the entrie doesnt appear. If I change to the end of 2028 than it will appear...
JMHenriques ,
That is what is expected. You are filtering on Contract Expiry Date field and hence it will filter out all data which is not having Contract Expiry Date betwen 2023 and 2027.
If you want forecasted values between 2023 and 2027, then you need to filter on Forecast Year.
Check this:The thing is that I needed to keep the total with all the years but only show some of them.
But in the meantime, I reformulated the idea and totals will be presented in another way so indeed I will do that 🙂 thanks for the feedback.