Change Date formatting in a calculated measure having Text format

[Alisea_MI]

I have an issue with displaying the YYYYMMDD format in a calculated measure. All my computer and Power BI settings are regionally correct. All my data columns have the correct format YYYYMMDD. My customer wants me to visualize the dates chosen in the filters and I use a calculated measure with MIN and Max dates to get the "First Selected Date" - "Last Selected Date" shown in my "Chosen Filters" visual. My problem is that dates shown in the "Chosen filters" visual are displayed in the MMDDYYYY format. Please see the attached picture.

Grateful for any ideas of how to change the format in the calculated measure to the YYYYMMDD?

Alisea

[amitchandak · Accepted solution]

@Alisea_MI , Not very clear on this .

But you can have text format like

in column = Format([Date],"YYYYMMDD")

in measure = format(Max(Table[date]),"YYYYMMDD")

[kirsty_clegg]

Thank you, I've just had the exact same problem and this has sorted it for me.

[Alisea_MI]

Thank you so much, @amitchandakamitchandak! Works super well!