In certain data set and filter choice from slicer, the bars' heights change filling up multiple rows and thus messing up the alignment of middle labels and the bars. e.g. when I choose 3 products where Male has 4 bars (age ranges) but female has 3 bars (or a different number than the middle labels). Any way around that? Thanks
![Megan Thee Stallion - Roc Steady (feat. Flo Milli) [Official Video]](http://i.ytimg.com/vi/HozPPyqW0dY/mqdefault.jpg)
I've finally found the perfect way to mirror a bar chart! Thank you!!!
I like the combo of using the slicers with a nice graph
Excellent, Congratulations.
more than great
In certain data set and filter choice from slicer, the bars' heights change filling up multiple rows and thus messing up the alignment of middle labels and the bars. e.g. when I choose 3 products where Male has 4 bars (age ranges) but female has 3 bars (or a different number than the middle labels). Any way around that? Thanks
Go to your Values, and choose Field Settings. On the Layout & Print tab, click the checkbox Show items with no data.
@@KnackTraining Beautiful fix! Thank you.