Date Formatting/Conditional Date Formatting

[dylantaylor]

Hello,

I have the following date information formatted in "Table" form on my report and wanted to know if I could change the formatting from the current style to just remove the day of the week. Is there a way that I can do this in report view?:

Here is a simulation of what the table looks like:

Customer	Next Survey Date
A	Wednesday, June 13, 2012
B	Friday, September 14, 2018
C	Monday, October 01, 2018

Also, can conditional formatting be applied to dates in report view based on the number of days between the reported date and the current date? For example, color all dates red that are more than 180 days before current date, yellow 90-179, etc.

Thank you so much for the help!

[amitchandak · Accepted solution]

@dylantaylor , I did not get it completely, But creating a color measure like

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")

And use that in conditional formatting. Use field option and then use this measure

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[amitchandak · Accepted solution]

@dylantaylor , I did not get it completely, But creating a color measure like

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")

And use that in conditional formatting. Use field option and then use this measure

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...

[dylantaylor]

Yes, you answered the conditional formatting question but not how to change the formatting. Is there a way that I can change the current formatting of the dates to exclude the day of the week as well? Thanks!

[v-chuncz-msft · Accepted solution]

@dylantaylor 

You may take a look at Display custom format strings.