Bar Chart - Suppress Dimension if Expression is NULL

[Saravanan_Desingh]

I have a situation here.

Dimensions : Strategic Direction & Site

Expression : Count(Name)

I want to suppress the Sites which didn't turn any value. I'm getting perfect output in Pivot Table.

But if I change it to Bar chart, I'm getting the above.

Suppress Null and other related options didn't work here.

Any suggestions here please? Thanks..

[sunny_talwar]

You can check 'Suppress When Null' on the presentation tab of chart properties.

[sunny_talwar]

I guess this did not work for you. May be try this as your calculated dimension

Aggr(If(Count(Name) = 0 or IsNull(Count(Name)), Null(), [Strategic Direction & Site]), [Strategic Direction & Site])

Check 'Suppress when Value is Null' on the Dimension tab

[Saravanan_Desingh]

Hi Sunny,

Thanks for your response.

There are two dimensions Strategic Direction and Site.

Based on your Calc-Dim, I have changed my case as below:

=Aggr(If(Count({<Freq={0}>}REMS_City), Site ,Null()), [Strategic Direction], Site)

But, as default all the Site names are coming. Not sure.

[sunny_talwar]

Would it be possible to share a sample?

[Saravanan_Desingh]

Please find the attachment. !

[sunny_talwar]

I guess this would be backdraw of using 2 dimensions and 2 expressions. How about the attached

[Saravanan_Desingh]

Thanks Sunny. This is very helpful.

But still if you get any other idea, please share it with me. Thanks again..

[sunny_talwar]

May be swuehl‌ has a trick in bag for us

[settu_periasamy]

Hi Saran,

As i know, there is no other way to do this. You need to make it as a single dimension (using '&' ) , so your 2 expression will be stacked. already sunindia suggested..

Just a small amendment..

i think, we don't need Aggregation. Just try

=[Strategic Direction]&Repeat(chr(160),6)& Site