Forum Discussion

Alexandra_B's avatar
Alexandra_B
Icon for Helper III rankHelper III
4 years ago

How 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 ...
DAX
Formula
Formula Help
Need Assistance
Need Help
Alexandra_B's avatar
Alexandra_B
Icon for Helper III rankHelper III
4 years ago

As 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's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
4 years ago

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's avatar
    Alexandra_B
    Icon for Helper III rankHelper III
    4 years ago

    Thankj you for your reply.
    I did, but is not much difference. I am attaching a snip. 😞