Could you attach your packaged workbook(***.twbx). With that people in the community can investigate more easily.
Reference lines apply to the entire axis. I'm not aware of any way to limit part of the axis they should apply. While there may be some creative solutions to this, certainly breaking it up into two sheets, one for each measure and aligning together on dashboard to simulate the look of one sheet would be one option.
Thank you , Phil
Because the data does only have one customer, and have trouble to set colors yet, anyway, here is my approach.
Create Dual axis chart with
"Sales Actual" and "Sales Actual YTD"
Then put reference line for respective axis,
Select per cell
And Sync Axis.
Create two Color definition fields for Actual and Actual YTD.
And put the color for respective measure.
At this point, only each measure has only one result. With your actual data , I believe you can set True as Green False as Red or something like that.
Ref lines issue_9.0.twbx 25.5 KB
It works !!!
Thank you very much
I have another issue now:
I would like to put the variance between data and reference line on the right side of the screen.
But if I do that, my data are shown on 3 lines. Is there a way to show the green bar (the variance) at the same level as the 'Sales Actual' bar?
I tried to play with the aliases but didn't solve the issue.
Ref lines issue.twbx 21.3 KB