Forum Discussion

mnt23's avatar
mnt23
Icon for Helper I rankHelper I
1 year ago
Solved

Best way to display changes in values

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?

Need Help

3 Replies

    • mnt23's avatar
      mnt23
      Icon for Helper I rankHelper I
      1 year ago

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

  • HCA's avatar
    HCA
    Icon for Advocate I rankAdvocate I
    1 year ago

    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.