Stacked Column Charts

Hi Lou,

Thank you for the forum question.

It is all about how your data model is build and your DAX measures.

Do you have a dim table with the gifts listed?

And do you have a fact table with all the gifts transactions?

It may be useful to see a screen of your data model (model view) and a screen shot of the chart.

Please send it to:

info@stl-training.co.uk


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Hi Lou,

Thank you for the screen shots.

I fully understand what you want to achieve, but unfortunately the 100% stacked bar chart does not support 2 values. I have been searching the Market Place for a third part chart, which could do it, but without luck.

There is a walk around. If you create two. One for each value, you can remove the background, titles, and axis from one of the charts, and then just put the charts on top of each other.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector