Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Actual vs Target

Hi,

 

I have a line and clustered column chart where I combine actual (bar) and target (line).
Green = above target, Amber = less than 20% below target. Red = equal or more than 20% below target

 
Then I change this in a line chart. It shows the actuals


And when I then add target to the Y-axis I get this

 


But what I would like to have is that for actuals it will only show the coloured markers. 
And for target the orange line without markers.

Is there a way to do this?

Regards 
Ron


  • Anonymous , With more than one measure, conditional formatting is not supported, so ideally one should not show you a colored marker.

     

     

1 Reply

  • Anonymous , With more than one measure, conditional formatting is not supported, so ideally one should not show you a colored marker.