The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |