Trim timestamp from Date parameter in power bi report builder(SSRS)

[Anonymous]

Hi All,

I am trying to remove timestamp from date parameter in power bi report builder. Below is my query for my date parameter.

EVALUATE SUMMARIZECOLUMNS('APPS SWN_EIS_LOS_SUMMARIES_V'[GL_DATE], RSCustomDaxFilter(@APPSSWNEISLOSSUMMARIESVFiscalYear,EqualToCondition,[APPS SWN_EIS_LOS_SUMMARIES_V].[Fiscal Year],Int64))

I tried below code but not giving any result.

EVALUATE
VAR _TempTable= SUMMARIZECOLUMNS ('APPS SWN_EIS_LOS_SUMMARIES_V'[GL_DATE],RSCustomDaxFilter(@APPSSWNEISLOSSUMMARIESVFiscalYear,EqualToCondition,[APPS SWN_EIS_LOS_SUMMARIES_V].[Fiscal Year],Int64))
Return
SELECTCOLUMNS(_TempTable,"GL_DATE",FORMAT([GL_DATE], "MMM-yy"))

I am using power bi dataset where date is alredy formatted but in power bi report builder(SSRS) its not happening.

Anyone have any idea how we can remove timestamp from date parametr in power bi report builder(SSRS).

Thanks in advance.

[v-chuncz-msft]

@Anonymous 

You can optionally provide a friendly name for values by specifying a label field.

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-change-or-delete-available-values-for-a-report-parameter?view=sql-server-ver15