Skip to main content

Power BI

Needs Votes

Line Chart Marker Color Conditional Formatting

Vote (128) Share
Girish Singhal's profile image

Girish Singhal on 21 Sep 2020 16:10:08

It really helps if we can do conditional formatting of Marker color on Line Chart.
That will help in distinguishing any data points that we want to highlight.

Currently work around of applying conditional formatting on Bar Chart and then converting it back to Line Chart works but the color/size of the marker gets obscured by the color scheme of (bar -> marker) for the chart itself. I tried to resize the marker size to 6 to reduce the footprint of default color scheme of "bar -> marker" but that renders the marker size to be very small. If I increase the marker size then the default color scheme renders/overshadows the condition color of the data point that has a special color (derived out of conditional formatting applied to bar chart before it was converted to line chart.

The same can be seen in the below screenshot.

Comments (3)
Girish Singhal's profile image Profile Picture

Vinicius Arantes on 14 Feb 2023 18:32:11

RE: Line Chart Marker Color Conditional Formatting

This would be great! An must be for almost all line charts who deals with "good / bad' values.

Girish Singhal's profile image Profile Picture

Holger Schimanski on 17 Jan 2023 12:36:30

RE: Line Chart Marker Color Conditional Formatting

See similar request https://ideas.powerbi.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909

Girish Singhal's profile image Profile Picture

Daniel Byers on 21 Apr 2021 17:28:22

RE: Line Chart Marker Color Conditional Formatting

Thanks for finding the workaround, which is still usable as of 2.92.706.0.

The ability to highlight individual points on the line chart based on the value of a specified field would provide valuable new capability, especially if able to customize the points beyond what is allowed by the bar chart to line chart workaround.