Forum Discussion
CREATE A TABLE VISUALIZATION WITH A RANGE OF DATES
So, not necessarily a great solution, but you could do something like create a new column with a formula such as:
Date Range = IF(TODAY()-[Date] = 0,"Today",IF(TODAY()-[Date] < 30,"< 30 Days",IF(TODAY()-[Date] < 60,"30 - 60 Days","> 60 Days")))
Then, create a slicer based on Date Range. You click the slicer, it filters the visualizations on the page to those date ranges.
Obviously, this does not give the user the ability to enter specific dates and such.
I know that parameters or input fields have been a fairly reoccuring feature request.
Perhaps I am not understanding what you are trying to do, but what about just using visualization/report/page filters?
Table
Date Column1 Column2
1/1/2016 xx yy
1/2/2016 xx yy
1/3/2016 xx yy
You would set your filter for values in Date after 12/31/2015 AND before 1/4/2016 for example.
Hi smoupre,
you're right, and thank you for the solution. But I expressed myself badly.
Your solution is perfect if I insert manually the values, but if want to use two calculated value like function TODAY() or TODAY()-30 as values? How can I solve it?
. . .
Meanwhile, do you know something about the implementation of "input fields" in Power BI? They would be perfect for me as a solution.
Still thank you so much for your fast answer!
So, not necessarily a great solution, but you could do something like create a new column with a formula such as:
Date Range = IF(TODAY()-[Date] = 0,"Today",IF(TODAY()-[Date] < 30,"< 30 Days",IF(TODAY()-[Date] < 60,"30 - 60 Days","> 60 Days")))
Then, create a slicer based on Date Range. You click the slicer, it filters the visualizations on the page to those date ranges.
Obviously, this does not give the user the ability to enter specific dates and such.
I know that parameters or input fields have been a fairly reoccuring feature request.
Thanks smoupre, it's a great solution!
Filtering on a dynamic date range is possible but the best solution will probably depend on your data source and model design.
For example we're using SSAS Multidimensional and have added a set of flags to our date dimension to show current month, year etc. We then just have to use these flags in a filter and the date range moves every time the report is refreshed.
You could do similar things in an SQL source or by adding a calculated column into your model after the data is loaded.