girish_singhal's avatar
girish_singhal
New Member
5 years ago
Status:
Needs Votes

Line Chart Marker Color Conditional Formatting

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.

8 Comments

  • 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.
  • See similar request https://ideas.powerbi.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909

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

  • EAB1977's avatar
    EAB1977
    Frequent Visitor
    How many votes are needed for the Devs to take on a request like this? It seems like something that could easily be added.
  • Be careful to show ONLY ONE series in this hack... otherwise you'll lost the customization icon even in bar charts... just remove all series but the one you wanna customize, apply the bars hack, convert to line chart again and then add all other series you need in your line chart
  • RPProhaska's avatar
    RPProhaska
    Regular Visitor
    Tearing my hair out trying to conditionally format markers. All the on-line articles on work arounds for this are dated and none of them work in the current PBI release. Microsoft, please add conditional formatting for line chart marker colors.

Recent ideas