How to display data on the chart for only one month by day with current filter context.

[Dmytro_13]

Good day, dear community. Stuck on this question. It is necessary to display the data on the chart only for one month by day, depending on the context of the filters (Year, Month). If neither the month nor the year is selected, then display the data for one month by days for the last year, month (where data is available). If month not selected, but selected year, then display the data for one month by days for the selected year and the last month of this year where the data is available. If the month and the year are selected, then display the data for one month by days for the selected year, month. If the month is selected, but the year is not selected, then display the data for this month by days for the last year. I will be very grateful for your help.

Here is the sctructure of the model:

[amitchandak]

@Dmytro_13 , if you need based on today, use this measure in visual or visual level filter

example

This Month Today =
var _min = eomonth(today(),-1)+1
var _max = eomonth(today(),0)
return CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...

[Dmytro_13]

Thanks for quick answer, but it is not exactly I want. For example, if I chose 2017 year, data disappear.