Forum Discussion
Multi Data Colors in Line Chart?
freakinaditya , you can not have that. You can have a color dot. Apply conditional fomatting by making this visual as bar and then make it like again.
You can use option as color scale or rule or field value option.
for field value you can create a measure like
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"))
refer 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
Thank you amitchandak , I have used similar to that what you said but it will only change color of markers (dots) in the line chart.