The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
Is there any way to put a default date for today or yesterday in the visual data slicer?
For exemple today is 4/23/2020 but when i open the report the slicer is:
Is there any way to open the report whenever the data slicer has the default date today or the day before? For example, in this case the slicer should have today's date 4/23/2020
Does anyone know how to solve this? can someone help me?
Best Regards,
JO
Solved! Go to Solution.
Hi @Anonymous ,
Maybe you could use relative date filter in Filter Pane. Then the between date slicer will still show date range.
Please reference:
Using the relative date range filter
You can check following article to create a slicer with custom defaults: (99+) Custom Range Date Slicer in Power BI with dynamic defaults and more... | LinkedIn
here's a result from a google search to help you : https://community.powerbi.com/t5/Desktop/Set-TODAY-as-default-date-in-slicer-visual/td-p/488670
Hi @Anonymous ,
Obviously i saw this solution, because i also searched on google, but it doesn’t help with anything i wanted.
Best Regards,
JO
Hi @Anonymous ,
Does that make sense? If so, please mark the helpful answer as the solution. Then we will be able to close the case. More people will benefit from here.
Hi @v-xuding-msft ,
yes, but what I intend is that whenever the report is refreshed the maximum slicer date is updated to TODAY
Best Regards,
JO
Hi @Anonymous ,
It will update with current date automatically. It is not a static date range.
Hi @Anonymous ,
Maybe you could use relative date filter in Filter Pane. Then the between date slicer will still show date range.
Please reference:
Using the relative date range filter
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
82 | |
63 | |
54 | |
52 |
User | Count |
---|---|
127 | |
118 | |
81 | |
65 | |
64 |