Conditional axis formatting

If you have a bar chart like the one below where there is a large difference in the data, then it can be difficult to rank the smallest bars or to be able to use them for drill-down because of their size.

mceclip0.png

Let us reduce the maximum scale.

mceclip1.png

The bars that shows the lowest values have become more visible.

mceclip2.png

However, at the same time some bars that “fall over the edge” because they represent values that exceed the axis maximum.

We can clarify this if we add a conditional text for these bars. We grab the advanced text editor once more.

mceclip3.png

With additional formatting, we can get this result.

mceclip4.png

Was this article helpful?
0 out of 0 found this helpful

Comments

2 comments
  • Hi, I am thinking of using a variable value instead of a fixed value for the limit.

    Can that be done, e.g. based on the average value?

    0
  • Hi Stephan,

    Yes. You can do that.

    You will probably need to work with measure axis and labels like this:

    Notice the "axis.avg" syntax. You can do quite a few things with regard to references to axis, columns and rows. See this article: https://community.targit.com/hc/en-us/articles/360017043017

    BR / Ole

    0

Please sign in to leave a comment.