Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
How to reflect a Date e. g. 07-Nov-2016 on Card Visual.
My requirement is that I am creating separate pages for Daily, Monthly and Annual surgeries.
As the report for today's surgeries will be seen tomorrow, I wish to display "Report Date" in a text box, followed by the date of report either on a Label or in a text box. e. g. Yesterday's report will be seen today hence the daily report page should display Yesterday's date.
How do I do it?
I have already created necessary relationships and a separate measure as:
Today = DATESBETWEEN(SurgeryMaster[Sx. Date],NOW()-1,now()-1)
I am using it in page level filter so that all visuals appearing on the page will be for yesterday.
Thank You.
Solved! Go to Solution.
Do want to always have the day before the "report date" of the latest surgery appeared in a card?
If so, you can add a calculated column which always display the "yesterday" of report date. Then create a measure return the max "Yesterday" and have it displayed in Card Visual.
Column = DATEADD(SurgeryMaster[Sx. Date],1,day)
measure = MAX(SurgeryMaster[Column])
Regards,
Do want to always have the day before the "report date" of the latest surgery appeared in a card?
If so, you can add a calculated column which always display the "yesterday" of report date. Then create a measure return the max "Yesterday" and have it displayed in Card Visual.
Column = DATEADD(SurgeryMaster[Sx. Date],1,day)
measure = MAX(SurgeryMaster[Column])
Regards,
Heartfelt Thanks. That Worked.....
Also I seek help in suppressing the Zero values in Visualizations.
Thanks Again.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |