Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi,
I would like to display today's date by using TODAY() function in a such format DD/MM/YYYY in a card visual .
However, together with the date I get time, say 22/01/2018 00:00:00.
How can I get rid of the time and display the date only?
Solved! Go to Solution.
...or you can use DAX FORMAT function measure = FORMAT(TODAY(), "DD/MM/YYYY")
@Anonymous, Select the measure then on the Modelling tab of Power BI Desktop you can format as desired.
...or you can use DAX FORMAT function measure = FORMAT(TODAY(), "DD/MM/YYYY")
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 17 | |
| 11 |
| User | Count |
|---|---|
| 55 | |
| 53 | |
| 41 | |
| 36 | |
| 32 |