Showing results for 
Search instead for 
Did you mean: 

date picker, how to add in a dashboard/report

My date dimension (relatively) big, spaning 20 years with one entry per day.

This means it doesnt fit into a slicer.

So far, ive been adding it to reports as a filter but when i give users access to dashboards and reports, i want them to be able to quickly select a different date in a friendlier way than modifying the page/report filter.


Is there a solution to this yet (web searches have provided nothing useful yet)

vik0810 Member

Re: date picker, how to add in a dashboard/report

I dont really understand what you mean, if you add a date column to a slicer, it transforms automatically to a date picker?


ouvar Occasional Visitor
Occasional Visitor

Re: date picker, how to add in a dashboard/report

Hello there!


I have the same need as a topic starter.


You see we want to create a dashboard only to demonstrate the data regarding the exact day of the years and only for one day. 


so what are the questions;

1. How to set up a single filter bar with a calendar view?

2. How can it be attached to "today -1 day" by default?


Thank you in advance

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 429 members 4,027 guests
Please welcome our newest community members: