Hide some values in a Table

[mendes094]

Hello, 

I have a graphic table and I need to hide when values in colunm "Zera..." = 0

Anybody can help me?

Tks!

[NoahF]

Hi @mendes094 ,

you can use a calculated Dimension for Zera, to replace 0 with null().

Then you can untick the option "Include Zero Values". The values will then disappear.

=if([Zera] = 0, null(), [Zera])

Regards, Noah

[mendes094]

Hello @NoahF , this collunm is a measure.

I think to do something in this area, do you can help me?

Tks

[NoahF]

If this is your only measure in the table. Then you can click on the table, go to "add ons" and untick the option "include zero value."

Untick this option and it should work.

[mendes094]

Hello, @NoahF 

According to the image sent above, this option does not appear, I believe it is because this column is a measure and not a dimension.

Don't have this option here. Can you help me?

[NoahF · Accepted solution]

You are looking in the wrong tab of the table. You are in the „Data“ Tab. Look in the image I sent above. This option is not in the measure as you sent in your picture but under the „add-ons“ tab of the table.

Collapse the data tab an look under add-ons. It is the third tab. 1. Data, 2. Sorting 3. Add-ons

[mendes094]

Thanks @NoahF 

Its work!!