Removing an entire bar from a barchart

[lisabarelle]

Hi all,

I'm trying to remove a bar from a barchart. I'm able to remove it visually by adding this in my expression:

sum({< [BAR_TO_REMOVE]=-{''} >}[sales]) / sum(TOTAL [sales])

But it still takes 'space' on my barchart.

Any ideas?

[JordyWegman]

Hi Lisa,

This is due to your Total in the second part. You could try 2 things:

1. Suppress zero values in your settings tab and null values in your dimension 

2. sum({< [BAR_TO_REMOVE]=-{''} >}[sales]) / sum(TOTAL {< [BAR_TO_REMOVE]=-{''} >}  [sales])

Jordy

Climber

[lisabarelle]

Thanks. Unfortunately, these solutions don't work given they end up providing a different measure. For example, (2) leads to a fraction of the sales over a subset of sales, not entire sales.

Any other ideas?

[JordyWegman]

Hi Lisa,

What about filtering it out of your data model? That would be the easiest solution.

Jordy
Climber

[lisabarelle]

Would be the easiest, but I still need these values for other graphs.