cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deepvibha Regular Visitor
Regular Visitor

Date on Card Visual or Text Box

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Date on Card Visual or Text Box

@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,

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Date on Card Visual or Text Box

@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,

Highlighted
deepvibha Regular Visitor
Regular Visitor

Re: Date on Card Visual or Text Box

Heartfelt Thanks. That Worked.....

 

Date on Label.png

 

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

 

Thanks Again.

 

Regards,