topic Re: I need create in DAX the button that will be show data with filter on date in DAX Commands and Tips

I need create in DAX the button that will be show data with filter on date

yakovleva_alena — Mon, 18 Sep 2023 14:48:33 GMT

I need create in DAX the button that will be show data up to this day (maybe with another filters on date)

Which commands can I use?

Re: I need create in DAX the button that will be show data with filter on date

tamerj1 — Mon, 18 Sep 2023 16:40:34 GMT

Hi yakovleva_alena

please provide more details perhaps with some screenshots.

Re: I need create in DAX the button that will be show data with filter on date

yakovleva_alena — Tue, 19 Sep 2023 07:19:18 GMT

I have some diagramms with data by month.
I can choose time interval using the button below, but i want to update date automaticly and show that from start of this year up to today.
So my question: how can i write code in DAX for automaticly updating date on button below or maybe on other button every day?

Re: I need create in DAX the button that will be show data with filter on date

ERD — Tue, 19 Sep 2023 09:54:24 GMT

yakovleva_alena , you need 2 filters for the slicer and a measure.

Measure:

check date = var today = TODAY() RETURN IF(MAX('Date'[Date]) > today, 0, 1)

Filters:

Re: I need create in DAX the button that will be show data with filter on date

yakovleva_alena — Tue, 19 Sep 2023 10:32:56 GMT

my problem a little different

i want to have slicer, where user can choose all time interval AND the button(not slicer), that open mark where data on diagramms from start of this year up to this day

and when user open the site he mast see data up to this day

i hope i can explain my issue correctly..(

Re: I need create in DAX the button that will be show data with filter on date

RSC — Tue, 19 Sep 2023 10:57:32 GMT

Hi yakovleva_alena ,
Don't know if I understood your problem properly or not, but when you're using this visual (Between Slicer), put the date filed and don't change the value of date in this slicer until you publish this report on power bi services,
I think this can help you.
Thanks

Re: I need create in DAX the button that will be show data with filter on date

yakovleva_alena — Tue, 19 Sep 2023 11:08:17 GMT

if i do this, i need every day change date on slicer, because every day i need to see data up to current date

Re: I need create in DAX the button that will be show data with filter on date

tamerj1 — Wed, 20 Sep 2023 12:19:38 GMT

yakovleva_alena
Please refr to attached sample file with the solution

Re: I need create in DAX the button that will be show data with filter on date

yakovleva_alena — Thu, 21 Sep 2023 13:10:54 GMT

Thank you very much, but it works only on slicer and does not affect on diagramm
I attached some screenshots from your file
maybe you can help me to connect date-filters and diagramms?

Re: I need create in DAX the button that will be show data with filter on date

tamerj1 — Thu, 21 Sep 2023 15:26:09 GMT

yakovleva_alena

Check the interaction between the date slicer and the chart