Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatg6759
Creator III

Remove Zero on X- Axis Bar chart

Hi Everyone,

I was getting 0 in the x-axis bar chart.Please help me how to remove it .It was coming because of using year to date function in dimension.

Check the attachment and also is there a way can i join both the charts in one.Expressions are same,but dimensions are different.

Thanks,

Venkat

15 Replies
Not applicable

what is your expression ?

Not applicable

not sure whats ur calculated dimension but you write something like if(yeartodate(...)=0,'')

venkatg6759
Creator III
Author

Dimension is Year2date(Date),Expression iam using dual to calculate the % and num

Not applicable

Can't you simply tick the check box "Hide Axis". Will that help?

Thanks,

Ram

venkatg6759
Creator III
Author

Thanks for your reply.If i remove the legend that's working .But i need to show dimension name in X-axis.Any ideas

Thanks,

Venkat

Not applicable

If you in a hurry situation, just use a text box to hide it

srchilukoori
Specialist

you must have checked the option "Text on Axis" option in the Expression tab. un-text on axis.pngcheck that option.

venkatg6759
Creator III
Author

Nope actually 0 is coming from calculated dimension. I had a dimension date field like 'DD/MM/YYYY'.when i use that i am getting graph as per every year but i need upto date.So, i used year2date which is causing that 0.

srchilukoori
Specialist

so you have two dimensions and three expressions on the bar chart. correct?

Can you please post the expression you are using in the calculated dimension.