Hi all,

I decided to blog each time I run into nice trick at the BI services.

I have counted 9 tips, so I will numerate them... ( just for fun)- it is always good to start from 10. (-:

Problem:

You have a table. you need to hide/unhide columns by specific parameter.

For example:

You have this table, you need to hide the Qi columns by a value of the parameter.

Solution:

Past this expression on each column visibility:

IIF(INSTR(Join(Parameters!StatementName.Value, ","),"x")0,False,True)

Change the parameter name to your parameter, change the x to the appropriate condition ex. "Q1".

Now, when you choose the Q1 parameter, only Q1 column will be seen, the other will be on hidden state.

Bye,

Ronen