Show Today's date on Dashboard

[vickyprudhvi]

Hi,

I am trying to see if I can display today's date on the dashboard. I know there is a way to do it when we import data into Power Bi desktop by creating new table and writing DAX function, which I was able to achieve but I am looking for a way to achieve this when we use live connection mode.

Thank you for ur help , guys

[Anonymous]

I am using the same formula to show Today's date on dashboard but it shows date & time as well. I don't want time to be showcase on dashboard, I just need today's date.

Can you guide me?

[kritikagrawal]

Hi @Anonymous , 

You can change the format in the measure tools. 

Click on the measure you have created and change the format to view only date. 

[ashishrj]

@vickyprudhvi I don't think there is any way to achieve this in Power BI Online but same can be achieved in Desktop Tool as explained by @cwayne758. 

Another way is, unless & until if you are connecting to SSAS Tabular live model then you can create a measure in tabular model and achieve the same by pinning tile to dashboard.

[vickyprudhvi]

I have been using =Today() function in tabular model but I am looking if there is anyother way to do it.

Anyways thank you for ur suggestions

[cwayne758 · Accepted solution]

use Now() function for a Measure.

Display the measure as a notecard like below.

 =Now()