cancel
Showing results for 
Search instead for 
Did you mean: 

Hide bars with "no value"

0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

Jay_Gandhi
Advisor
Advisor
0 Kudos

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

0 Kudos

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
Advisor
Advisor
0 Kudos

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
Active Contributor
0 Kudos

Hi Armand,

Your photo's you refer to are not visible.

Kind regards,

Martijn van Foeken | Interdobs

0 Kudos

Hallo Martijn,

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