Forum Discussion
Concatenate Labels option does nothing?
Same problem. NOTHING works. I have 2 fields I am using for the X-Axis.. both are text fields having nothing to do with dates. "Category" and "Subcategory". When I select those two for my X-Axis and select an integer Count field as the Value... then take a look at the X-Axis properties.. there is NO "Type: Continuous/Categorical" option available whatsoever... presumably because it is text values being used for the X axis rather than numeric (?) When looking at the chart (selected clustered bar chart), I have the ability to drill down from the category-looking barchart to the subcategory-looking barchart but neither has X-axis labels that display both category and subcategory labels so there is no concatenation of labels happening anyway. Not surprisingly, nothing happens when I turn "off" the concatenation of XAxis. I have tried everything from all suggestions in every combination of sequence imaginable and this is the most frustrating waste of time EVER. Think I will go back to good ol' Excel where life is simple and intuitive.
This is what i tried and it worked!
Shared- Axis - Create the required hierarchy and add
Column Values - Added two measures
Drill down to the lowest level in the hierarchy (In My case it is Month under Year, Quarter, Month)
X axis settings : Turn off Concatenate Labels
This is what we generally try to do -- change settings in the format tab.
But the key that i see here is sort option which you can modify using the top right corner.
We need to sort the Visual by the heirarchy mentioned in the Shared Axis. In my case i saw a sorty by option - Sort by -> Year Month Quarter.
Once done i see the required output.