Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
use Now() function for a Measure.
Display the measure as a notecard like below.
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?
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.
@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.
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
use Now() function for a Measure.
Display the measure as a notecard like below.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |