How to maintain position of values in column chart when filtered?

[Anonymous]

Hi All, 

I have a column chart, segmented by 6 categories (Pallet, Endcap, etc...) and some year over year card metrics below each associated category for YOY and YOY % (left visual) 

When someone selects a slicer,  the columns move to the middle, which throws the alignment with the KPI's below out of whack. 

Is there a way to keep the columns in the same spot when sliced so the columns stay over the cards associated with each category? 

I've tried a few things such as editing interactions - but looks like you can't do 'highlight' with the slicer and column chart, only 'filter.' 

Before slicing

After Slicing (pallet card is on the left, but columns move to middle) 

 Thank you kindly!

[ImkeF · Accepted solution]

Hi @Anonymous ,

looks like you have to activate the setting "Show items with no data" in the axis or your column chart: