Just Video no Sound!
First thanks to Kurt (Buhler) (LinkedIN: / kurtbuhler ) for his amazing Line Chart Overview (example ´s can be downloaded here: github.com/dat...)
For all who havvn't the new Power BI Desktop, you can download the .pbix here: 1drv.ms/u/s!Al...
I have to admit that I find it sometimes a bit diffecult to recreate charts, thats why I make this One Minute Monady video!
Here are the steps for the Line Chart Make Over:
Note: I missed the switch on Y-Axis - but I guess this is a matter of taste 🤣
Line Chart - Thresholds (Comparison to target or threshold)
1) Chart Type: Line Chart (Basic Power BI Visual)
Right click on "Month" date field: Show item with no data!!!
2) Title: THRESHOLDS/ Subtitle: COMPARISON TO TARGET OR THRESHOLD
3) X-Axis: Values - Max area hight = 50%/ Title: off
4) Y-Axis: on / Range: Minimum = fx = Zero/ Maximum= fx = 120% Highest Sum
5) Secondary Y-Axis: off
6) Legend: off
7) Marker: on / Type: Dot/ Size: 8px (apply onyl to Sum lates data point)
8) Data label: on / Apply setting to: Average = off/ Sum (Latest data point) = Under/ Values: 14/ Decimal places: 1
9) Reference Line: Add Line = Target/
Line: Value = fx = Threshold/ dashed/ in front
Data label: on = position: right/ Style: both
10) Error bars: on / Series: Average/ Type: by field/ Upper bound: Thereshold (high)/
11) Error band: on / Style: Fill/ Transparency: 66%