I have a dashboard like this, and I want to hide the profit column from the time horizon 2015 Q1, Q2, Q3 and Q4.
But when I right click "Hide", it hide the whole Profit Columns!
I just want to hide it like Excel.
Does your true datasource allow for pivoting of measures?
Pivot Data from Columns to Rows
If so, you can write a calculated field to filter:
[Pivot Field Names]="Profit"
AND YEAR([Order Date])=2015
Please see workbook attached in Forum thread.
Retrieving data ...