Hi,
Is it possible to hide/show column from Measure Names(Values) by parameter value? I have simple boolean parameter with 2 states: hide/ show some column (f.e. discount in attached file). I want to hide this column with header by switching parameter value.
I've already tried hiding column values (just made them equal to "" when parameter value is "hide"), in this case I actually have an empty column with a header. I've also tried switching sheets by parameter value in the dashboard, but perfomance was slow and I had to adjust size of each column on different sheets.
Thanks in advance.
Hi @Andrew Nikolaev ! Unfortunately, Measure Names and Values cannot be used in calculated fields or parameters. You can vote up the idea here though.
I thought of a "hacky" way around this depending on your scenario and size of your table. I've attached a workbook where if we list the measure that is hiding as the last column and change the alias of the Measure Name to " " then we can just remove everything from that column so it looks like the table is just extended. This also has a label floating above the table that's connected to the parameter. I understand this is not ideal for a very wide table, but if you're working with a smaller table, this is one way around.
