Forum Discussion

deepvibha's avatar
deepvibha
Advocate II
9 years ago
Solved

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 surge...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

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's avatar
    deepvibha
    Advocate II
    9 years ago

    Heartfelt Thanks. That Worked.....

     

     

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

     

    Thanks Again.

     

    Regards,