Change data point color when overlapped (line chart)

[Anonymous]

Hi Everyone

I have a line chart that is being created by multiple measures to show the data points (dots) on the line. This is how it is being created in PBIX. I converted the lines (A, B, C, D, E) into dots and Total remains as the blue line in the chart. However, there are some data points where multiple data points (dots - A, B, C, D, E) will overlap each other on the blue line (Total). Would like to know if there is a way to change the color of the dot to Black when there's an overlap in the data (refer to second screenshot below).

Current chart

Overlapped data points (want to change the dot color to Black)

Regards,

BK

[v-lili6-msft]

HI  @Anonymous 

To my knowledge, your requirement couldn't achieve for line chart in power bi for now.

Regards,

Lin

[amitchandak]

@Anonymous , i doubt that is possible. as conditional formatting is not allowed with multiple values on line/bar visual. Check if its working. Create a color measure whenever two values match. Use that in conditional formatting using "Field Value" option in bar first and then change visual to line.

example measure

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))

Color  = if(FIRSTNONBLANK(Table[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)>2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions
"red"
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

Hi @amitchandak 

I am not too sure what you mean. Can you show in PBIX?

Thanks & Regards,

BK