How to EASILY create gauge charts with target lines using standard visuals in Power BI

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/superstore-dataset/workspace/file?filename=Fact_Customer_Order.xlsx

https://data.world/deanchereden/superstore-dataset/workspace/file?filename=Dim_Date.txt


🔖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 - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden

🎵 Vhsceral - Gimetime https://chll.to/dd82e17f

🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4