Hide bars with "no value"

[former_member749303]

Hallo every one,

I want to ask who how i can hide the bars with "no values" in my chart? (see photo 1).

I already selected "Zero suppression" as you can see in the next photo (photo 2), but it still shows the bars with "no value"

Thank you very much!

[Jay_Gandhi]

Hi Armend,

Hard to be sure unless you provide a full screenshot of the entire chart, however, it almost looks like those are values for the Region that has no member (#, unassigned).

Could you filter out the unassigned member in the Region dimension?

Jay

[former_member749303]

Hallo Jay, thank you for your reply. I added the entire chart to the question.

What do you mean by "filter out the unassgined member in the Region dimension"?

Do mean by that to click on this filter? (see photo) I clicked on the filter and in the selection there are only listed all regions.

[Jay_Gandhi]

Hi Armend,

Yes from your new screenshot it seems clear the "no value" is suggesting there is data sitting inside of an undefined member of Region.

Not sure what your data source is? If you go into the filter of your third screenshot and filter on only one Region I assume it'll work as expected?

If you cannot filter out"unassigned" click within the chart where it says "no value" and use the exclude option.

Jay

[mfoeken]

Hi Armand,

Your photo's you refer to are not visible.

Kind regards,

Martijn van Foeken | Interdobs

[former_member749303]

Hallo Martijn,

thank you for the information. I just added the photos.