How to remove Null Bar from Bar chart

[bhavvibudagam]

Hi Experts,

Can anyone please help me on this.

In the below bar chart I need to remove the [Null] bar from the Partner Dimension.

I have to remove only from this chart in UI not from the complete app in the backend.

Please help me on this.

Thanks in Advance.

[Anonymous · Accepted solution]

Use as a dimension

=if([Partner Dimension] = '[Null]', null(), [Partner Dimension])

and then uncheck the box "Show null values" on the dimension

[devarasu07]

Hi,

try below methods,

Method 1) Try to suppress null value from your dimension field  "Partner"

Method 2) try to exclude null using set analysis expression

let say you have measure as Sales then

sum( {$<Sales={">0"}>}Sales)

or

sum( {$<Partner={"=Len(trim(Partner))>0"}>}Sales)

Thanks,

Deva