Hi all
I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data.
There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no longer within the filtered data. Does that makes sense? I want the reader of the data to see that the category is there but empty.
Thanks in advance for any and all ideas.