Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I would like to add today to a date slicer for the between slicer setting. I have a set day say 1/1/2023 and set the last date to be today instead of static date selection.
Is that possible to do in power BI? for example in the picture below instead of 2/28/2024, the selection would be today.
Solved! Go to Solution.
You can create a calculated column with the following code:
Date Range =
VAR _Start = [Date]
VAR _End = TODAY()
RETURN [Date] >= _Start && [Date] <= _End
Then add this column as a filter on the visual and set the filter to True
Hi @powerbisupcl ,
Have you tried using any custom visual for Date slicing? because belive me they are life savers when it comes about functionality and features.
I am talking about custom visual named Date Picker by Powerviz. Not just Today, it provides a lot of presets which are really useful with little to no need to write dax that too with custom / in built themes.
I think you should check them out.
Here is a link if you want to check this visual - https://appsource.microsoft.com/en-us/product/powerbivisuals/truvizinc1674781244292.date-picker-by-p... (I believe they offer a free version too)
You can create a calculated column with the following code:
Date Range =
VAR _Start = [Date]
VAR _End = TODAY()
RETURN [Date] >= _Start && [Date] <= _End
Then add this column as a filter on the visual and set the filter to True
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |