Hide an expression in the chart when a dimension of the Cyclic group is selected

[#1]

Hi All,

I have a Cyclic group showing the dimensions Year, Quarter and Week.I would like to hide an expression when a Week is selected.

Any ideas would be of great help!!

[NickHoff]

Add a conditional to the expression which is GetSelectedCount(Week) <> 0

[neelamsaroha157 · Accepted solution]

try this in conditional show of expression

=If(match(GetCurrentField(Cyclic_Field), 'Week' ),0,1)

[#4]

Hi Neelam

Thanks for your response.

The Cyclic group i am using is: Cyc_Dimension_4 and Week is the dimension i have tried using your expression to hide the column

=If(match(GetCurrentField(Cyc_Dimension_4), 'Week' ),0,1)

but no luck!

[#5]

Hi Nick Hoff

Thanks for your response.

I am using a Cyclic group in my case so the condition mentioned doesn't work.

[MK9885]

In conditional expression use

if(yourdeimension)=yourdimension,0)

or

if(yourdeimension)=yourdimension,0,1)

In your case

if(Week)=Week,0,1) or use if(week)=week,0 (To hide that dimension always related to that particular expression)

[MK9885]

Just use

if(Week)=Week,0) and it will hide if you select Week in table for that expression.

Write this condition in Backlog(K) expression as shown in image below.

[neelamsaroha157]

Try to add double quotes like

GetCurrentField("Misc Group")

and

Single quotes for your dimension field name 'Week'

[#9]

I tried the way suggested by you Neelam but no luck...

The table i am using here is the Pivot table does that make any difference?

[neelamsaroha157]

Check this