Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi there,
I have a date slicer setup. It is in the form dd/mm/yyyy.
I also want to display the start and end date into a Title. So I have created a measure with the following DAX:
StartDate = CALCULATE ( MIN ( [date] ), ALLSELECTED ( [date] )
EndDate = CALCULATE ( MAX ( [date] ), ALLSELECTED ( [date] )
The EndDate displays as m/dd/yyyy instead of dd/mm/yyyy
The StartDate displays as a RANDOM date that is fixed and does not change (in my case: 5/1/2023)
How can I fix my StartDate? Is there a way to show the value as a measure? Is there a way to format the date slicer to be mm/dd/yyyy to be in sync with the Title?
Thanks
StartDate = CALCULATE ( MIN ( [date] ), ALLSELECTED ( [date] )
looks like you are mixing the concepts of a measure, a column and (potentially) a table.
Measures require table references when pointing to columns.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.