Suppress null value from bar chart

[neha_sri]

I have a bar chart which is showing '-' as dimension. I want to remove /hide it.

I have tried suppress null value but it is not working for me.

How can I remove it/

[neha_sri]

This is my sample chart

[sinanozdemir]

Hi Neha,

In your expression, you can write something similar to the below:

Count/Sum({<Dimension = {"*"}>} Value)

Dimension is the dimension causing null values.

Hope this helps.

[sunny_talwar]

Have you tried 'Suppress When Value is Null' on the Dimensions tab of the chart properties?

[robert_mika]

Do you want to hide members of the dimension or remove the whole dimension?

If the latest you can just move the dimension from Used Dimension window into Available fields

if the first try here:

[buzzy996]

try tis,

[neha_sri]

I have trend line chart. This option is not present

[neha_sri]

This also is not working for me

[neha_sri]

Yes, but its not working

[giakoum]

a sample app would help as all straight forward suggestions do not work for you.

Most likely the problem is in your expressions