Power BI Report Builder | How to get your date parameters to actually *work*
Struggling to get your paginated report to use date parameters with that nice clean "date picker" look? It's tricky, but it's doable--let me show you how!
This video walks you through how to create a date range parameter using the Query Designer, then make a few key updates to get the final result--start and end dates that actually work!
---
Visual Basic for reference (to format date types to text, which--let's agree--feels silly, but works!)
=Format((Parameters!FromDateDate.Value),"yyyy-MM-dd")
=Format((Parameters!ToDateDate.Value),"yyyy-MM-dd")