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. (-:
You have a table. you need to hide/unhide columns by specific parameter.
You have this table, you need to hide the Qi columns by a value of the parameter.
Past this expression on each column visibility:
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.