Best way to display changes in values

[mnt23]

Afternoon team, 

I am looking to dispaly changes in values in a data set. The baseline values are fixed, so I've taken a cut of the data before any changes. I then have a separate table that has the live data. Each line has a unique ID so it was easy to create a relationship and then measure that calculates the live difference. 

I can display that on its own, but I'd like to overly it on the baseline data. I've done a hasty sketch of what I'm imagining:

The graph on the left shows the baseline data, and the one on the right shows me having draw the changes on - increases in red and decreases in green. 

I'm not set on the exact visuals, but that's the type of thing I'm trying to create. 

I've drawn a blank having done a bit of trawling for answers. Can anyone help?

[HCA]

Hi, Please try the following, 

->In Power BI, load both the baseline data and live data tables. Ensure that the unique ID field in both tables is correctly related (a 1-to-1 or 1-to-many relationship, depending on your data).

->In Power BI, you can create a DAX measure to calculate the difference between the baseline and live data for each ID.

Example: Change = [Live Value] - [Baseline Value]

->Create a chart (line, column, or bar chart) to display the baseline values on the left side. Use the Baseline Value for your Y-axis, and the ID (or relevant field) for the X-axis.

->Add another chart or series on top of the baseline chart to show the difference. You can either use a stacked bar or line chart, where the baseline is the bottom layer and the difference is stacked on top, or use overlaid bars/lines, where each line/column represents either the baseline or the change. For each change (positive or negative), apply conditional formatting to colour the bars/points: Red for positive differences (increase), Green for negative differences (decrease).

->If you're overlaid, make the baseline layer a bit transparent to make the change layer more prominent. Alternatively, if you're using two separate charts, ensure they align well and don't clutter the visual.

->Fine-tune the layout to match the visual style you want. You can adjust colors, legends, tooltips, and axis labels for better clarity.

If this helps, please let me know.

[lbendlin · Accepted solution]

Kurt Buhler just posted an article about that

Building bullet charts in Power BI reports - SQLBI

[mnt23]

Sorry for the slow reply, got dragged into something else. This is exactly what I was looking for, thanks.