2 Replies Latest reply on Apr 12, 2018 11:03 PM by May Ching

Hiding every second year label but keep the data values in plot.

May Ching Apr 10, 2018 8:41 PM

Hi,

I was wondering if it is possible to hide every second water year label in a bar chart plot whilst keeping the bar data values and bar chart of that year on the plot.

I am asking because when I customize the size of the dashboard the Years get all cramped together in a row. I do not want to rotate the labels because the plots will be

going into a report.

The dashboard currently looks like this:

I wanted to know if this is possible:

Thanks for your help!!

1. Re: Hiding every second year label but keep the data values in plot.

Cathy Bridges Apr 12, 2018 4:09 PM (in response to May Ching)

If you can change your x axis to continuous, this is possible by right-clicking and selecting edit axis, then change the tick marks. But if your year/month is text or something that you can't convert to a continuous field then I'm not sure it's possible.

Although another option would be to create a date field even if your data is text. Convert a Field to a Date Field
Like Show 0 Likes(0)

Actions
2. Re: Hiding every second year label but keep the data values in plot.

May Ching Apr 12, 2018 11:03 PM (in response to Cathy Bridges)

Hi Cathy,

Thanks for your reply. The data that I am using has data that needs to be aggregated from 01/07 to 30/06. This means the current and previous water year is always used e.g 2006-07, 2007-08, 2008-09 etc. I know this is not the standard format for a date field which means converting to a continuous field is not possible. Just wondering if anyone else has encountered this limitation that is possible in Excel Spreadsheet through the axis format options and changing the date intervals displayed on the plot.

Regards
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Hiding every second year label but keep the data values in plot.

1. Re: Hiding every second year label but keep the data values in plot.

2. Re: Hiding every second year label but keep the data values in plot.

Actions

More Like This