Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have a problem regarding using a continuous x-axis with YearMonth dimension values in a bar chart. It turns out that if the number of entries is below a certain number, the free places are filled with duplicate date entries:
Obviously I want that only one entry is shown. I am using the continuous dimensions to show a x-axis reference line, which is not possible without using this option.
I hope someone can help me with this issue.
Thanks in advance,
David
you are using callculated date dimension in Xaxis , so thats why it is duplicating ....use like this
Year(Date)&'-'&num(Month(Date)) as x-axis dimension
Hi,
thanks for your answer.
In this case I wont receive a dual date format, which is required for using the continuous label. With your formula I receive the error "no numeric values on x-axis".
Kind regards,
David
for continuous labeling go to sort and sort by following expression ascending
=only({1}Date)
They are not really duplicate date values. They are day values in between. If you change your format to include the day you can see this. The continuous format generates it's own value labels based on dividing the range.
What you need is some way to make the font invisible on the labels you don't want. Something I can't figure out how to do on a bar chart off-hand. Maybe suppress the dimension labels and use Text on Axis for the labels? You can't get the slanted labels though.
-Rob
Hi Rob,
thanks for your helpful answer.
Your suggestion of using an additional expression to display the months via text on axis is useful, but unfortunately the number of entries shall not exceed a certain number in order to prevent the readability of the dimension.
Kind regards,
David