Forum Discussion
Helper IIIHow to filter the date
Hello.
Been trying this for the whole day and don`t know where I`m messing up.
Please see the snip
So I have a formula where I need to add filtered data.
I am able to select the years and filter it by years, but I want starting from June 2021, not Janurary 21 onwards.
I have tried to use DATESBETWEEN and it`s even worst (see the second Adj_b graph.)
The date in HDD starts on 01/07/2019.
Thank you.
5 Replies
daXtremeSolution Sage
Hi there
Not entirely sure what you want to achieve. If you want all your graphs to start in June 2021, then use the page filter to make this date the very first visible. If you want something else, please be more specific.
Alexandra_BAs you can see in the picture, there is a range of 2019 - 2022 data. If I choose to filter the date using the filter, I can filter it by Months, year. But that means I will have the same months, and I don`t need the same months every year, just half year 2021 and then full year next one. (or I don`t know how to set it otherwise). I want a graph to show data starting from June 2021 onwards, not June 2021, June 2022, etc
On top, I put a DATEBETWEEN formula, but the graph still shows 2019, 2020 years.- daXtreme
Please use a filter on the page (not on the visual). This is one of the filters in the right-hand side pane. If you do this, then everything on the page will be relative to the date range you desire. Manipulating the context in the measure is pointless in this case.