Date on Card Visual or Text Box

[deepvibha]

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.

[v-sihou-msft · Accepted solution]

@deepvibha

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,

[deepvibha]

Heartfelt Thanks. That Worked.....

Also I seek help in suppressing the Zero values in Visualizations. 

Thanks Again.

Regards,