Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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
You may take a look at Display custom format strings.
@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
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!
You may take a look at Display custom format strings.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |