Forum Discussion

Anonymous's avatar
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 visu...
Need Help
  • v-easonf-msft's avatar
    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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity 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