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)
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.
RE: Line Chart Marker Color Conditional Formatting
See similar request https://ideas.powerbi.com/ideas/idea/?ideaid=bf62a5fa-d376-ed11-a76e-281878bd0909
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.