Forum Discussion
conditional marker colors in a chart
Hi madhas ,
Please try:
First create a new measure:
Measure = IF(SELECTEDVALUE('Table'[Date])<=DATE(2023,5,12),"gray","blue")Then conditional format your data:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Here is the sample data:
| X | Y | Date |
| 1 | 2 | 2023-05-15 |
| 2 | -2 | 2023-05-14 |
| 3 | 1 | 2023-05-13 |
| 4 | -2 | 2023-05-12 |
| 5 | 5 | 2023-05-11 |
| 6 | 4 | 2023-05-10 |
| 7 | 2 | 2023-05-09 |
| 8 | 2 | 2023-05-08 |
| 9 | -2 | 2023-05-07 |
and here the sample plot:
as I did in this case I need to gray out the points older than 2023-05-12. Of course in this case I changed the colour of each point manually, but it is not feasible when it comes to large set of data.
Whether the new points are in multicolours or not is not important. The thing is that the older points should get grayed.
Thank you
Hi madhas ,
Please try:
First create a new measure:
Measure = IF(SELECTEDVALUE('Table'[Date])<=DATE(2023,5,12),"gray","blue")
Then conditional format your data:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.