Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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")
@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")
Thank you, I've just had the exact same problem and this has sorted it for me.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |