Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I would like to color the date column as below :
IF date < 2 months : RED
2 - 4 months : Orange
> 4 months : green
Name | Value | Date |
Name 1 | Value 1 | 09/10/2023 |
Name 2 | Value 2 | 20/09/2023 |
Name 3 | Value 3 | 20/09/2023 |
Name 4 | Value 4 | 20/09/2023 |
Name 5 | Value 5 | 10/03/2023 |
Name 6 | Value 6 | 11/03/2023 |
Name 7 | Value 7 | 12/03/2023 |
Result :
Could you please advise ?
Thank you in advance.
Tg
Solved! Go to Solution.
@vnqt You can use rule based conditional formatting to color the date column. You can refer this video to know how to implement rule based conditional formatting.
https://youtu.be/Fq0JneLDbGs?si=hTyyxWF-407Acrbp
If you find this insightful, please provide a Kudo and accept this as a solution.
@vnqt You can use rule based conditional formatting to color the date column. You can refer this video to know how to implement rule based conditional formatting.
https://youtu.be/Fq0JneLDbGs?si=hTyyxWF-407Acrbp
If you find this insightful, please provide a Kudo and accept this as a solution.
User | Count |
---|---|
21 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
14 | |
13 | |
11 |