Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

FIlter data on visual for date until now

dear all,

thank for reading and help me as below

i have a visual with starting date 4/1/2020 (m/d/yyyy)

the date column have till future time like 6/1/2020

I want to filter the visual and date slicer until today only.

i am try to write a DAX with datesinbetween but it not wokrs, measure not infor wrong but visual not show.

How can I deal with this case? thank you

v-easonf-msft
6 years ago
Hi, Anonymous
Here is a demo.
You can create a calendar table as below:
Date = CALENDAR(DATE(2020,4,1),TODAY())
After establishing the relationship, use the date field in the calendar table to create a slicer to filter the fact table.

You can refer this post to create a new column and apply it to slicer .
You aslo can take a try of the relative date slicer to achieve the similar result.

Best Regards,
Community Support Team _ Eason

4 Replies

Anonymous
Not applicable
6 years ago
You can add a filter on Filters and choose between the dates you want to see it on the chart.
- Anonymous
  Not applicable
  6 years ago
  sorry, i want it automatically filter till today, and slicer limit to today only
amitchandak
Super User
6 years ago
Anonymous , Drag your date to page-level filter and use <=today. So last X year including today
v-easonf-msft
Community Support
6 years ago
Hi, Anonymous
Here is a demo.
You can create a calendar table as below:
Date = CALENDAR(DATE(2020,4,1),TODAY())
After establishing the relationship, use the date field in the calendar table to create a slicer to filter the fact table.

You can refer this post to create a new column and apply it to slicer .
You aslo can take a try of the relative date slicer to achieve the similar result.

Best Regards,
Community Support Team _ Eason