Forum Discussion
Helper IFormatting Date Parameter Dropdowns in Paginated Report
Hi everyone, I have a Paginated Report that I created using Power Bi Report Builder, I have created parameters StartDate and EndDate.
The Dates shown in the parameter dropdown are in the format "mm/dd/yyyy" along with time. I want to change the format of values in the parameter dropdowns as "dd/mm/yyyy" with no time. I was able to change the format of data in the report itself but not on how they are displayed in the parameter dropdown. So is this possible or not?
1 Reply
Hi rdini8 ,
You could try adding a text box and displaying the value as a parameter, changing the expression to Format() to customize the date format
This is the related document, you can view this content:
Solved: Report Builder Parameter Formatting (Datetime to D... - Microsoft Fabric Community
reporting services - Changing the SSRS date picker format to DD/MM/YYYY - Stack Overflow
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
