Deleting null values from a bar chart

[sdaniels0606]

Hello,

I have a problem with a bar chart. When I try deleting the null values I dont need, the chart creates a new label named "-".

To delete the Null values I use "Alt(expresion,' ')" or "If(IsNull(Expresion),' ',Expression)".

-->

BTW, the values Im trying to erase are from a second expression without bars.

[sunny_talwar · Accepted solution]

Once you use your calculated dimension, you need to check 'Suppress When Value Is Null' on the dimension tab of the chart properties to hide those null values

[surendraj]

Hi,

Here is the another way,with out using the supress null values,we can restrict it by using set analysis.

sum({<sales-={'0'}>}sales)

--surendra