Forum Discussion
Two Measures to Draw One Line
Hi MPetramalo214 ,
Are you trying to show different colors on the same line, like this?
Currently Power BI does not support conditional formatting of the color of the line chart, you can suggest your idea here.
https://ideas.powerbi.com/ideas/idea/?ideaid=0671c26d-bd0e-43ad-b78c-bb097f2c54af
Just as a workaround, you can try other visuals or superimpose two fold lines as follows.
Put the measures into the Values/Secondary values pane separately, then close the legend, set the color of [Above Goal] and [Running Sales] to the same, and turn on the "Series labels" option.
Then the final result will be:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not trying to get one line with two colors; I actually was trying to force one line to be conditional on if we're above goal on the max day we're filtered to, and the other to be conditional on if we're below goal.
Which ever is true, would draw the line - and because its two measures, I can manually set the color of each.
All the following is being manually manipulated by me; but is how I would envision this working. But I understand if this is not a feature yet.
Above Goal:
Below Goal:
The problem I am currently running into, is that instead of the entire series of dates being calculated by each measure; the measures are only calculating when that day is above/below goal:
