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