Hide dimensions values basing on measure, Graph

[Mt3]

Hi,

I am making a bar chart, where I would like to hide Dimensions labels when it's measure value is zero.

I tried base if statement, but as we cannot  have nested conditions in dimensions, this solution have not worked.

If ((sum(a)>0), b)

Unchacking "include zero values' on dimensions levels and in data handling did not worked.

Do you have any workarounds on your mind? I would like to avoid doing such calculations on load, thus I am basing on chart statements.

[Andrei_Cusnir]

Hello,

You should try going to Add-ons > Data handling and Un-check the option "Include zero values":

1. Before:

2. Option:

3. After:

As you can see the dimension with 0 values are not there!

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members. 
 

[Mt3]

Thank you for your response . That did not work, as mentioned in the post - inclusion of the condition is still needed here.

[Andrei_Cusnir]

Hello,

Can you please elaborated in detail as to what you mean "inclusion of the condition is still needed here" ? Do you mean that you must have the option "Include zero values" enabled?