Рет қаралды 988
In this video, I'll explain how to configure a data label on a Power BI line chart to show the current value plus the change between the current value and the value of the previous week.
This is helpful because the reader of the chart can quickly establish the exchange change from the prior week without having to carry out this calculation in their head.
In addition to the change from last week, I'll also add an up or down indicator. This further reduces the cognitive load because it makes it explicitly clear if the value is higher or lower than the prior week.
Obviously, this will also be apparent by the position of the data point in relation to the point the previous week on the y-axis (e.g. above it is higher, below is lower) but I think the indicator adds an extra touch to make it even easier to read the direction of change.
Finally, I'll modify the chart so that it displays only the first data label value and the values for the last 5 weeks. This is useful for a few reasons.
1. It simplifies the chart by removing data points that are not particularly relevant. In our case, we are increasing the number of characters displayed for each data label so it makes even more sense to simplify the chart by removing some of these labels.
2. Adding the first data point provides the reader with an orientation point. Following the trend line from this point forward allows the reader to understand the direction of the trend from that starting value onward.
3. Generally speaking the further back in time we go, the less we are interested in the actual values. This is not always the case but let's assume it is for this example. Displaying the data labels for the last 5 weeks helps focus on recent performance.
----------------------------------
⏩ Video Navigation
----------------------------------
00:00 - Intro & why this is useful.
00:46 - Activating the data label dynamic format
02:15 - DAX code overview
06:00 - Issue if a string is not returned
Only display the first and last 5 values
06:45 - Data model overview
07:52 - Dax code overview
08:21 - Code for the first date with a value
10:10 - Table of last 5 dates with values
11:36 - Logic to show or hide data label
12:40 - Don't show PW difference for the first value
14:00 - Adding a sub-title to explain the value in brackets
-----------------------------------------------------
🎥 Related Videos
-----------------------------------------------------
Triangels for up and down change indicators (copy those below or visit the URL listed)
▲ ▼
Source: www.alt-codes.net/triangle-sy...
A good guide explaining DAX FORMAT function
dax.guide/format/
-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
effectivedashboards.com/power...
👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that help you, your boss, and your peers make better decisions!
effectivedashboards.com/power...
-------------------------
📁 Resources
-------------------------
👉Access to the source PBIX files for this KZbin video:
effectivedashboards.com/cours...
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-...