Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I need to achieve the automation of date range bar acording to the automation of Last Update.
For example, if Last Update is 01/10/2018, then the date range bar should move to the 01/10/2018, automatically and not manually.
Any suggestions?
Thanks
Regards
Solved! Go to Solution.
@salta,
The method I can think of is to create a calendar table using DAX below. Then create relationship using date field of the date table and the date field of your original table. And create a slicer using date field of date table.
Date = CALENDAR("5/29/2018",TODAY())
Regards,
Lydia
@salta,
The method I can think of is to create a calendar table using DAX below. Then create relationship using date field of the date table and the date field of your original table. And create a slicer using date field of date table.
Date = CALENDAR("5/29/2018",TODAY())
Regards,
Lydia
| User | Count |
|---|---|
| 13 | |
| 8 | |
| 7 | |
| 5 | |
| 5 |