B I Posted January 21, 2019 Share Posted January 21, 2019 Hi all, I need to reset a bar chart so that the categorical axis, which is a four-tiered hierarchy, is programmatically reset to the "least specific" level. How can I go about doing this The only way I can think to do this is: barChart.As[barChart]().XAxis.Expression = barChart.As[barChart]().XAxis.Expression.replace("3","0").replace("2","0").replace("1","0")The issue is that it is difficult to write an expression for a chart on a categorical axis if the axis requires an alias. Thus, in the above, I edit the existing expression to change any value of "hierarchy level" to 0. It isn't a very good way to achieve this as it requires me to replace every value level individually, meaning that if more levels are added to the hierarchy then I will need to add these values as a separate replace function. Does anyone know of a better way to achieve this Cheers, Ben Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now