Visual help for custom grouped cluster chart

[pjukone]

Hi all, I was wondering if anyone has come across somthing like this or can help.  I have three measures one for actual , one for the remaining forecast (ie total forecast less actual) and one for budget. 

I was trying to put them in a stacked bar chart (like the below) so that the actual and forecast on one bar is stacked against the budget bar (which is not stacked).  What would be ideal is also showing the total of the actual and foreccast against the total budget (I have worked out how to do that part on a combo - line and stacked column chart although this chart is virtical and not horizontal which I needed to save space) 

I have searched a number of sources, and could not find any clear way of just doing this, therefore any help would be really appreciated.

[radhey_rec · Accepted solution]

Hi @pjukone ,

I am not very sure, if I have understood your requirements very clearly. But Given the appearance of chart, you can create one in PBIVizEdit. 

You can modify similar chart https://pbivizedit.com/gallery/budget-vs-actual:

Thanks,
-R

[pjukone]

Hi Radhey,  This is exactly what I had been looking for, this took me a long time googling this, but you found the solution staight away.  A big thank you for your help with this!

[Kmcdonald]

Have you tried to unpivot the data set in power query?

This will only work if you create a single column of that status (actual/forecast/budget), then another with the value on each status. You may need to transform the data slightly before that but could be effective for your scenario. 

You just select those 2 columns, plus whatever fields you still want to bring over, and unpivot from there.

Then you'd need to clean up your stacked chart visual, to use the new fields 😊

[pjukone]

Hi Kmcdonald,  The values are in a measure, thanks for your help, I think the above solution of the visual did the trick.

Kind regards,

P