Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 119 | |
| 100 | |
| 72 | |
| 69 | |
| 65 |