Build a DATE PICKER in Power BI Desktop

Have you ever wanted a single date picker in your Power BI report? Patrick shows you how to build one within Power BI Desktop!

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

*******************
LET'S CONNECT!
*******************

***Gear***

#PowerBI #GuyInACube

[samtoulayl]

Hi Patrick, thank you for the trick but it will make much more sense if Power BI team makes a date picker by default since this is a really basic reporting need.

[jonsnowboard]

Nice video. Love the way the Guy in a Cube videos are always entertaining - can see that you guys are passionate about BI reporting, as am I. I've been doing BI for a while but you opened my eyes with the possibilities in this video.

[agnespitka]

I like that he went through the other options at the beginning that I had already tried. That way I knew I would get an answer.

[dmiradakis]

Nice video, love your enthusiasm, Patrick!

[nataliamedvedeva]

Thank you a lot! Your video helped me to find a decision of my problem

[dakinsvibe]

Had this exact request in the last couple of days, ideal. Thanks Patrick, super helpful as always!

[driouchemountasir]

Hi Patrick, awesome video as usuall !! Love that kind of tips. You guys from GIAC help a lot. Thanks for that

[TTfromOZ]

Great trick! needed it some time ago. But I am sure I will need it again!

[Javilanderos]

I have not had a need yet for this but can see how I can implement this in future projects. Glad I saw the video because I assumed there was a calendar icon I could use that would do single dates. Now I know. Thanks.

[nhuquynhnguyenngoc]

It’s really helpful. Thanks for your sharing. Best wish for you

[akhilannan]

I had a similar requirement recently. What I did is created a calculation group named Single Date Activator, with logic: CALCULATE(SELECTEDMEASURE(), FIRSTDATE(Calendar[Date])). So whenever users want measure to be applied on single date they put the calculation group as a filter in report and all measures will be switched to single date.

[smanzoli]

I use a visual called Beyond Soft Calendar. You can add info to the dates, and also you can click any date to filter the report. Very nice!

[AnalyticswithNags]

he he awesome . This is absolutely a workaround. Suits well for small projects. Project with 100's of Measures will be difficult to maintain.

[BritonWells]

Good solution. Worked through this with a client recently and to avoid changing all the measures we used the new hierarchy support on slicers and did a simple year / month / date hierarchy. Only caveat here is that even with single select enabled you can "single select" at any level of the hierarchy, so users may end up selecting a whole month instead of a single day. Given the 100s of measures used, the compromise was worth it

[flchange]

It would be even more bananas if Microsoft added a functionality like that out of the box. 😉 but thanks for the video, I messed around with that a lot.

[frehiwotfitamo]

I am at a loss for words, It is marvelous. Appreciated

[markherd]

Thanks for the suggestion, I have implemented this and got it working as I have dozens of measures I needed duplicates of every measure which was very confusing both to me and any future user. I have resorted to ripping this back out, deleting dozens of excess measures and relying on users to select a single date. Please, please Microsoft add this as a standard option. It is a basic reporting requirement and this work around is too cumbersome for large dashboards.

[reesourcesinc]

Thank you so much!! I had this problem weeks ago.

[shashankgupta]

Hi Patrick, Thanks for the amazing video. Just wanted to check how to implement two date pickers, like start date and end date in one viz.

[martinturcotte]

Why in the world is there *STILL* no single date mode for the Filter Visual?!?! It boggles the mind. While I love DAX (only since I went through the Mastering DAX class) and I certainly appreciate this patchwork type solution (until you need to enable the border which would highlight the presence of whiteout patch, which would require a patchwork border as well to compensate), it makes PowerBI seem so incomplete compared to other BI offering on such a rudimentary requirement. This is the kind of detail that I continually had to work around for my last customer. Really painful.