Date Parameter Showing up list
Hi Community, I am using Power BI Report builder and I have to create one start date and end date parameter which should be < Today(). I have created two different Dataset each for start Date and end Date and Passed in "Available Values" Section of paramters. But unformatunately instead of Calendar it is not showing up list. I tried Cdate(Fields!Date) expression as well and somewhere i read Calendar will not work if we pass available values. What is the workaround to Provide Date parameters where users can select dates prior to today only? Thanks, PravinHow to set calender option in date parameters in report Builder?
Hello guys, I need an urgent solution for Report Builder. I have created the parameters subscriber number, start date, and end date. For a moment I have the date in text format in default.I want to change the format of the date from the text to the date format so that I can apply the calendar option for my customer. Can anyone tell me how to change the date format in the report builder? I have tried to change the format of date by selecting data type in parameter properties but it didn't work. I think I have to change something in Query. Can someone tell me what I am missing here? Thanks in advance 🙂
