Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
Click the Slicer button under Visualizations and Drag the Date column from your Calendar Table to the Field
Are you trying to do this in the query or in the report? The basic equivalent in reports are slicers.
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/
Click the Slicer button under Visualizations and Drag the Date column from your Calendar Table to the Field
Thank you Sean! This is really nice illustration! 🙂 I will try it.
Thank you so much!
Also look at my response here you may find it useful too
http://community.powerbi.com/t5/Desktop/Display-a-range-of-dates/m-p/141047#M60772
Thank you for additional answer, it's wonderful!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |