Bar chart with relative change

[Bobbys]

Hello!

I'm trying to create a bar chart for this year vs last years sales and was wondering if there is any way to show the % change from last year's numbers to this year's numbers, without having to create individual text boxes? 
This is how my bar chart is currently looking: 

As you can see I've manually inserted text boxes in order to show the changes. This however is not very practical or aesthetically good looking. Does anyone know if there is a custom visual which can show this, or if there is a way I can make my own chart show the % change? None of the custom visuals I've tried have worked. 

Thanks in advance. 

[Anonymous]

Hi  @Bobbys ,

You can use Format-Shapes-to open the Shade area, and an area will be formed according to the data of the line chart for better display:

Result：

Does this match your expected result, if not, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Bobbys 

Check this custom visual: 

Hierarchical Bar Chart

 

[Bobbys]

It's not allowing me to compare with last years data. As the "Measure data" input can only hold one measure, while I have a measure for this year and a measure for last year.. 

[AlexisOlson]

One possibility is to use a line and bar combo chart where you put labels on the line and set it to the background color.

Here's an example:

I've used gray instead of the background white for purposes of demonstration.

It's certainly not a perfect solution but not terrible for a hacky workaround.

[Bobbys]

Thanks for the tip!! For some reason, my chart gets kind off messed up when attempting this. This is how it looks: 

However, when holdning my mouse on the line the percentage changes do have the correct values.

If I get this to work this might be a possible solution!

[AlexisOlson]

You might need to tinker with the secondary y-axis in the format pane or modify your measure to not output huge numbers like that.

[Bobbys]

Thanks, I managed to fix it. However, it's still not optimal as some of the data disappears under the title etc. Really strange why it should be so difficult to visualize a fairly simple chart.