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 BI Community Team,
I have a date table, month and date. To getting more easy for user to choose the start and end date of the month.
We want to create and apply the slicer that have start and end date as the screenshot below.
Any suggestion/advise?
Sample pbix file: https://drive.google.com/drive/folders/1v66vRAhwzL2XIddDmhFEDjJXKXHNjPO7?usp=sharing
Thanks and Regards,
Solved! Go to Solution.
Make Sure that both filter & slider are connected to Date filed from Calendar table
also make sure to edit interactions for both filter and slider to filter eachother
@ADSL
Your are looking for a date slider that will return sales during a aspecific period!
Slicer Calendar.pbix
check If this is what you are looking for.
Hi @MohTawfik,
Thank you for your helpful feedback.
As per your screenshot and file pbix sharing, it's correctly working. But when I am trying to create the new with more data, then it's not working. It's still showing the 01/01/2022 and 31/12/2023.
Date seem not to be following the Year + Month selected. I am not sure file, it's manual choose or dynamic follow the month.
Please kindly check and advise if I am doing wrong.
Make Sure that both filter & slider are connected to Date filed from Calendar table
also make sure to edit interactions for both filter and slider to filter eachother
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 |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |