Forum Discussion
Helper IIIHow to filter the date
Solution SageHi 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.
Helper IIIAs 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.
- Alexandra_B
Thankj you for your reply.
I did, but is not much difference. I am attaching a snip. 😞
- Alexandra_B
I managed to filter it by year, 2021 and 2022 in the first graph.
I have tried to sort the data to calculate a specific period, so I added the formula with DATEBETWEEN, and periods required. Unfortunately, it still shoes all the date range from 2019, even if I selected June 2021 to today's date. I don't know how to get rid of 2019 - 2020, half of 2021 data 🙂 (see second graph).