How to hide certain elements of a dimension in a chart?

[Anonymous]

Hi

I came across this question where I can't figure out how to hide "var" and only display "Bud" and "Est" from the Type Dimension.

Anyone knows how to do this? Any difference if I'm using a straight table vs a pivot table?

Thanks

Zixiao

[maxgro]

try this

use a calculated dimension instead of Type

if(Type<>'Var', Type)

and check suppress when value is null

[saurabh5]

hi ZiXiao,

you may require to create a new field using if condition something like:

if(Type='var',' ',Type) as Modified_Type,

this will create a blank space if you have 'var' as field value.

Thanks

Regards

Saurabh

[Anonymous]

Thanks Massimo and Saurabh for your answers.  The calculated dimension does remove 'var' field value, however it doesn't remove the measure though.   This is how the chart looks like now... and I did check 'Supress when value is null'. Any way I can remove the whole row with measure value?

Thanks

Zixiao

[Colin-Albert · Accepted solution]

Try this. The -= in the set expression may show a red underline indicating an error but the expression will work.

     sum({<Type -={'Var'}>} Amount)

An alternative is

     sum({<Type ={'Bud, Est'}>} Amount)

[anbu1984]

Sum(If(Type <> 'Var',Amount))

Or

Do you want to hide rows if Sum(Amount) is negative?

If(Sum(Amount)>0,Sum(Amount))