Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
we have a requirement to display single date filter option for user to select date and filter the reports accrodingly.
Currently we see when we set single selection option either in date slicer or in filter pane, we see only drop down list and not a calendar pop out. Whereas for date slicer with betwee/after/before options we have calendar pop out option.
Users are not happy to scroll down the list through hundreds of rows to select the date filter they want.
Is there a custom slicer view that i can download and use? or any work around to display calnedar pop out for single date selection?
Any help is greatly appreciated!
I have already seen the GuyintheCube's video released in May, and he is calculating each metric by passing the selected date as filter using variable. That will not work for me, as i am displaying calculated MTD measures in my report. Also, his option might impact the performance.
https://www.youtube.com/watch?time_continue=184&v=zhWtU0DynCk&feature=emb_title
-
Thanks
Shilpa
Hi @Anonymous ,
Please try the methods in the following blog and check if it can achieve your requirement:
Using a Single Date Picker with Conditional Filtering in Power BI
In addition, here is one similar idea shared on Power BI Ideas , you can vote it up and add your comments there to improve Power BI on this feature.
Best Regards
Rena
@Anonymous , there is timeline slicer, but it looks too big
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |