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

[yakovleva_alena]

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?

[RSC]

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

[yakovleva_alena]

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

[ERD]

@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:

[yakovleva_alena]

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..(

[tamerj1]

Hi @yakovleva_alena 

please provide more details perhaps with some screenshots. 

[yakovleva_alena]

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?

[tamerj1]

@yakovleva_alena 
Please refr to attached sample file with the solution

[yakovleva_alena]

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?

[tamerj1]

@yakovleva_alena 

Check the interaction between the date slicer and the chart