No sound just video!
Line Chart with target area and variance labels
(Comparing Current Year and Last Year Revenue)
Chart Type: Line Chart
Y-Axis: Date Hierachy (Year/Month/Weeks)
Type=Catergorical
X-Axis: Growth %/ Revenue/ PY / Under Target/ Above Target/ Up and Down/ Zero/ 150% of Highest Line Revenue
Min: Zero
Max: 150% of Highest Line Revenue
For the colored area in the Background we need the Error Bars + PY Measure
1) Error Bars: on/ Upper Bound: PY /Lower Bound: Zero/ Error Band: on
For the red and green Marks/ Lines go to Format your Visual pane
1) Marker: Above Target = green/ Under Target= red
2) Lines: Above Target = green/ Under Target= red/ Revenue = grey
3) Data Label: on
Above Target = on and green/ Under Target= on and red/ Revenue off
For Growth %: Values - Custom label: Up and Down
Values Color: Up and Down Color
12 окт 2023