SETVISIBILITY can be used to show or hide rows, columns, and measures.
| NAME | DESCRIPTION |
|---|---|
| SETVISIBILITY(ROW_NAME) | Show or hide specific row categories |
| SETVISIBILITY(COLUMNS) | Show or hide specific columns |
| SETVISIBILITY(MEASURE_NAME) | Show or hide specific measures |
| SETVISIBILITY(ROW, COLUMN) | Show or hide a measure for a particular row category |
Show or hide specific row categories - passing a value of TRUE will display the row, and passing a value of FALSE will hide it.
SETVISIBILITY(ROW_NAME, BOOLEAN_ARG)ROW_NAME - Name of the row category to show or hide.
BOOLEAN_ARG - Set to TRUE to enable the rule. Set to FALSE to disable the rule.
SETVISIBILITY([United States], FALSE) #Hides the United States row category and all child nodes under it
SETVISIBILITY([International], TRUE) #Displays the International row category
SETVISIBILITY([Technology], THIS) #Use with a toggle variable to show or hide the technology category.png)
Show or hide rows using set visibility
Show or hide specific columns - passing a value of TRUE will display the columns, and passing a value of FALSE will hide it.
SETVISIBILITY(COLUMNS.COLUMN_NAME, BOOLEAN_ARG)COLUMN_NAME - The column to be shown or hidden.
BOOLEAN_ARG - Set to TRUE to enable the rule. Set to FALSE to disable the rule.
SETVISIBILITY(COLUMNS.[2019 > Qtr 1 > Actuals, FALSE) #Hides the Actuals measure for 2019, qtr 1
SETVISIBILITY(COLUMNS.[2019 > Qtr 1 > March > Plan, TRUE) #Displays the Plan for 2019, Q1, March
SETVISIBILITY(COLUMNS.[2019 > Qtr 1 > March > Plan,THIS) #Use with a toggle variable to show or hide the Qtr1 Plan.png)
Show or hide columns using set visibility
Show or hide a particular measure - passing a value of TRUE will display the columns, and passing a value of FALSE will hide it.
SETVISIBILITY(MEASURE_NAME, BOOLEAN_ARG)MEASURE_NAME - Name of the measure to be hidden.
BOOLEAN_ARG - Set to TRUE to enable the rule. Set to FALSE to disable the rule.
SETVISIBILITY([Plan], FALSE) #Hides the Plan measure
SETVISIBILITY([Actuals], TRUE) #Displays the Actuals measure
SETVISIBILITY([Actuals], THIS) #Use with a toggle variable to show or hide the Actuals measure.png)
Display the Actuals measure using set visibility
Show or hide a measure for a particular row category and column. Passing a value of TRUE will display the row category for a particular column and measure. Passing a value of FALSE will hide it.
SETVISIBILITY(ROW_NAME, COLUMNS.COLUMN_NAME, BOOLEAN_ARG)ROW_NAME - Name of the row category to show or hide.
COLUMN_NAME - Name of the column to show or hide.
BOOLEAN_ARG - Set to TRUE to enable the rule. Set to FALSE to disable the rule.
SETVISIBILITY([[Furniture], COLUMNS.[West > Sum of Profit]], FALSE) #Hides the column for a row category
SETVISIBILITY([[Furniture], COLUMNS.[Central > Sum of Quantity]], TRUE) #Shows the column for a row category
SETVISIBILITY([[Furniture], COLUMNS.[Central > Sum of Quantity]], THIS) #Use with a toggle variable to show or hide the Quantity for furniture.png)
Setvisibility row and column
