Bar Chart Blank Values

[#1]

Hello,

Does anyone know how to hide those months for 2016 that do not have data in them yet?

Thanks!

Channing

[sunny_talwar]

Try checking 'Suppress When Zero' on the presentation tab of the chart properties

[#3]

That is already checked and does not work, probably because I have 3 dimensions.

[swuehl · Accepted solution]

That's true, try creating a combined Year-Month dimension instead of your two grouped dimensions.

[sunny_talwar]

I guess then you can use calculated dimensions, but can't think of how it would work. Is it possible to share a sample to test it out a little bit?

[#6]

This did work but do you know how I can sort this to show 2014 1-12, then 2015 1-12, then 2016 1-current month?  The following sort property is giving me the bottom chart sort which shows the last 3 months for 2014 and 2015 at the end..

[swuehl]

Try to create your dimension like

=Dual( FINANCIAL_YEAR & ' ' & FINANCIAL_MONTH, FINANCIAL_YEAR*12+FINANCIAL_MONTH)

[Or just use a Year Month date field created in the script]

Then sort by numeric value.

[#8]

Great suggestion I made a year month date field.  Thanks so much!