Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to create Time parameters in power bi desktop

How to create start and end date parameters like in ssrs in power bi desktop? I tried to create a new parameter button, but don't know how to add 2 parameters to control the data. Any help will be appreciated.

2 ACCEPTED SOLUTIONS
Sean
Community Champion
Community Champion

Click the Slicer button under Visualizations and Drag the Date column from your Calendar Table to the Field

Date Slicer Between.png

View solution in original post

Sean
Community Champion
Community Champion

8 REPLIES 8
Greg_Deckler
Super User
Super User

Are you trying to do this in the query or in the report? The basic equivalent in reports are slicers.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thank for the prompt answer. It's for report. User wants to review the report by selecting date range.

 

For many years date values, it's impossible to use slicer for me. Here's the slicer tutorial I've found.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-slicers/ 

Sean
Community Champion
Community Champion

Click the Slicer button under Visualizations and Drag the Date column from your Calendar Table to the Field

Date Slicer Between.png

Anonymous
Not applicable

Thank you Sean! This is really nice illustration! 🙂 I will try it. 

Sean
Community Champion
Community Champion

 Date Slicer Between.gif

Anonymous
Not applicable

Thank you so much!

Sean
Community Champion
Community Champion

Also look at my response here you may find it useful too Smiley Happy

http://community.powerbi.com/t5/Desktop/Display-a-range-of-dates/m-p/141047#M60772

Anonymous
Not applicable

Thank you for additional answer, it's wonderful! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.