Forum Discussion
Visual help for custom grouped cluster chart
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
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 😊
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