I am looking for any insight or assistance on trying to show axis/category labels for every category in a serial chart within an Operations Dashboard. Currently, I have a dataset that uses a column to group records by specific values (age range; 0-19, 20-29, 30-39,etc). When entering this data into a serial chart and using the "Group Values" option in the "Data" tab, I am unable to get every category in the column to appear/be labeled in the serial chart. Specifically I am finding this occurs when there are 0 (zero) entries or records that have this value. I have tried using the "+ Override" and "Load Categories" option in the "Category axis" tab, but this does not resolve this issue. I believe this is occurring due to the value I need labeled not occurring the dataset (zero records with that specific value). I also have a "Filter" being used on this chart, although I am not sure if this would have any effect on the ability to have all labels visible on the serial chart.
What I need is for regardless of the number of records with these values, for the labels to be displayed on the serial chart. Is there an option within the serial chart to allow for this functionality?
For anyone that is having a similar problem, I have found a minor workaround utilizing ArcGIS Arcade. As an FYI, this workaround builds a new table/featureset in Arcade and will remove any dynamic connectivity from the original data.
See attached images/code for the Arcade Expression and the configuration of the serial chart