Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Line Graph Conditional Formatting

Hi, I was wondering if there was a way to color code a line graph. I looked it up, and on some versions of Power BI, there is either an advanced option on the Data colors editor, or 3 vertical dots ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I feel like I am close, but I am not sure how to encorperate the Red and Green dots if it is above or below last years totals...

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous 

 

You need to go to the line chart options:

  • Shapes
  • Customized series
  • Select the higher and lower
  • Line size 0
  • Show Marker on
  • Select the marker and color to your liking
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi MFelix 

    for some reason my version does not have the options after line style like you do...