The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Team,
I am working on to create a report and have a requirment to filter the data defaulted to previous month. I am using the date slicer displayed as between. Whenever i open the report for first time, my data has to filter with date defaulted previous month. I would appreciate any suggestion/help in acheiving this.
Example
PBIX file has the following. When i open the report all visuals will show the data for previous month date. Once i select the date range, visual has to show the data for the date range
Slicer
1. Date ( Using between)
Visuals
1. Card
2. Bar Chart
3. Table
Please let me know if you need any further information from my end
Thank you!!
Solved! Go to Solution.
Hi @manojsv16,
Currently, it is not supported to set default selection for a slicer. The slicer can keep the selections that you made last time you view the report, when you open it next time, it shows the same selections. In your scenario, you should change the slicer type to relative, like below.
Best regards,
Yuliana Gu
Hi @manojsv16,
Currently, it is not supported to set default selection for a slicer. The slicer can keep the selections that you made last time you view the report, when you open it next time, it shows the same selections. In your scenario, you should change the slicer type to relative, like below.
Best regards,
Yuliana Gu
Hi Yuliana,
Thank you!!
Hi,
Try to use Relative date filters.
Hi Ashish,
Thanks a lot for the response!!
I tried using relative date filter and it is working when we open the report for first time. But, I am not able to change the range of the date after open the report. Can you please let me know whether we can acheive in any way
Thank you!!
Sorry but i will not ba able to help.
Hi Ashish,
Thats fine. I appreciate your input.
I would wait others to help!!
Thank you!!
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 June 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
89 | |
70 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |