Not able to "connect" filter to panel

[Orlovaaaa]

Hello everybody! Why is that if I use this visual:  , and insert there the "date of sale" of my data, it segments this visual  , but if I insert there a DAX formula: "filter= DATESINPERIOD(Sales[Date of sale],(TODAY()-90),-9,MONTH).", it doesnt filter my  ?

[Anonymous · Accepted solution]

Thanks for the reply from @Gaga_Jin  and @Ronak131290 , please allow me to provide another insight: 
Hi  @Orlovaaaa ,

According to your formula, do you want the table VISUAL to be dynamically filtered by date based on minimum date (TODAY()-90),-9,MONTH),maximum date (TODAY()-90))

Here are the steps you can follow：

1. Create measure.

Flag =
var _today=TODAY()
var _maxdate=_today - 90
var _mindate=DATE(YEAR(_maxdate),MONTH(_maxdate)-9,DAY(_maxdate))
return
IF(
    MAX('Table'[Date]) >= _mindate&&MAX('Table'[Date])<=_maxdate,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

If the results above don't meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Orlovaaaa]

Thank you @Anonymous ! Your answer definitely helps and its a very interesting approach. Finally could get the problem solved. 

[Gaga_Jin]

@Orlovaaaa  , hi 

i think it's not working because you are using this dax formula to create measure. 
just create new table from "modeling" section in power BI, write a dax fromula like this:

Date = ADDCOLUMNS(

    CALENDAR(MIN('Sales'[Order Date]),MAX('Sales'[Order Date])),

    "Year", YEAR([Date]),

    "Month", MONTH([Date]),

    "Month-Year", FORMAT([Date], "MMMM-YYYY"))

rewrite calendar function arguments as you wish (as your data requires). 
after creating the Table make sure that it's connected with your sales Data.  relationship must be one-to-many. 
after that, let's create matrix or table. in the slicer field use Date which you created with dax formula. 

[Orlovaaaa]

Thank you!

[Ronak131290]

Hello Orlovaaaa,

Required More imformation about you issue.

Need more clrification for your issue.

[Orlovaaaa]

Thank you