I'm using the 100% Stacked Column chart visualization for my data. I have two groups of data organized by month. For example:
January Group A: 70%, Group B: 30%
February Group A: 60% Group B: 40%
March Group A: 50% Group B: 50%
X Axis is the Month and Y Axis is the Percentage
I need to hide the percentage values from Group B from the graph so that it shows Group A percentage rate on a monthly basis. However everytime I hide Group B the percentage calculation for Group A jumps to 100%. Any way to prevent this from happening. Struggling big time with figuring out a solution or workaround.
Why don't you just use the normal stacked column chart with the Y axis fixed to range from 0 to 100. If your measures are percentages and always combine to 100% (when both used) then the two charts will be the same.
However in a normal stacked column, if you have your measures normalised to percentage, if you hide group B, then Group A shouldn't stretch to 100%