Forum Discussion
Area Chart - Shade - Conditional Formatting for Multiple colors
This visuals above are good examples of what I am looking for. An area chart with green shade while the trend line is above the target line and red for below. I understand I can do this with the data labels and markers on the line, but it appears the area chat shading does not have the ability to use conditional formatitng for its color. Has anyone found a work around for this? Ideas?
2 Replies
Anonymous
It is not possible to have conditional formatting for Line and Area Chart
But i found this work around
First Create Column Chart ! Create a measure for color and apply on the dAta colors for Column CHart
and then change the column chart to Line. The line Markers will be with custom color !
https://drive.google.com/file/d/1iWvKfEELzOJfCGxXr6L6feuZ_bCzGbl-/view?usp=sharing
This video gives you idea
I knew that was a possibilty as noted in the question I don;t love how that visual looks. If I was really desparate would it not be possile to split the measure for the line into two new measures one as all the positive variances and one as all the negative and then simply use both measures in the visual, give negative red shading and the positive green?
