conditional marker colors in a chart

[madhas]

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. 

[madhas]

@lbendlin 

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 

[v-jianboli-msft · Accepted solution]

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.

[lbendlin]

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-...
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/1447523