Forum Discussion
conditional marker colors in a chart
I have a set of x, y value which I want to depict in a chart. Is it possible to color the markers based on a third value (for example date)? I want to gray out all x, y with dates < Date_0 and make the points with date >=Date_0 colorful.
I appreciate any help.
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.
3 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Here 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.
