topic Re: Not able to "connect" filter to panel in DAX Commands and Tips

Not able to "connect" filter to panel

Orlovaaaa — Sat, 27 Jul 2024 00:06:22 GMT

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 ?

Re: Not able to "connect" filter to panel

Ronak131290 — Sat, 27 Jul 2024 07:00:54 GMT

Hello Orlovaaaa,

Required More imformation about you issue.

Need more clrification for your issue.

Re: Not able to "connect" filter to panel

Gaga_Jin — Sat, 27 Jul 2024 09:33:13 GMT

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.

Re: Not able to "connect" filter to panel

Anonymous — Mon, 29 Jul 2024 08:21:48 GMT

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

Re: Not able to "connect" filter to panel

Orlovaaaa — Wed, 31 Jul 2024 14:39:54 GMT

Thank you

Re: Not able to "connect" filter to panel

Orlovaaaa — Wed, 31 Jul 2024 14:44:27 GMT

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

Re: Not able to "connect" filter to panel

Orlovaaaa — Wed, 31 Jul 2024 14:47:21 GMT

Thank you!