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.
Hi,
Please can you tell me how to allow a user to set a date variable (on a report page) which will then be used by a calculated measure?
I tried clicking on "New Parameter" expecting to see an option to enter a date but there doesn't appear to be such an option?:
Thanks,
CM
Solved! Go to Solution.
I use a slicer for dates and allow them to pick a single date or a date range. That value then becomes the selected value for the measure.
Hi @JoyCornerstone, thanks - is that a normal slicer or a parameter slicer? How did you set the data type to "date"?
A normal slicer. In your data model, you should have a Calendar table that contains a date range for the set of dates in your system. If you don't have that, you'll need to go search for how to set that up and connect it to your underlying table.
Thanks @JoyCornerstone , sorry but how do you get the selected value into a parameter/measure? If I create a slicer doesn't that just filter the underlying tables?
Fantastic, thank you
I found a workaround. Just set the parameter up as a whole number, then find the parameter's field in the list of data tables and change the data type to date. That seems to change the parameter slicer to accept dates.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |