Sometimes you need to see how a metric is performing against a target but over a period of time, or categories, in a chart.

This is easy to achieve in Power BI using error labels to create target lines in a standard column or bar chart, and you can find out how in this video.

#PowerBI #DAX #PBICoreVisuals


Dataset for Sales Data and file for original dim date table M code

https://data.world/deanchereden/super...

https://data.world/deanchereden/super...


c h a p t e r s

00:00 Intro
00:49 Load in data
01:50 Create a gauge column chart
01:56 Create measure for y axis
02:11 Set month name for x axis
02:48 Create a target measure
03:41 Create target lines
07:12 Add green or red conditional formatting
09:10 Add variance data label with arrows
13:03 Create a dynamic title measure
14:46 Add conditional formatting to title
15:44 Add conditional formatting to border
16:43 Change to a bar chart



My email [email protected]
My website https://www.deanchereden.com
Twitter   / deanchereden  

Vhsceral Gimetime https://chll.to/dd82e17f

Listen to Chillhop Music    • Misha & Jussi Halme  Bliss (A Felici...