SETBLANKLABEL

SETBLANKLABEL can be used to replace blank row or column categories with custom text.

Syntax#

SETBLANKLABEL.<ROW/COLUMN>(VALUE)

Arguments#

VALUE - Pass the custom value to use instead of blank categories.

Example#

SETBLANKLABEL.ROW('row_label')
SETBLANKLABEL.COLUMN('col_label')

SETBLANKLABEL function used in a variable

Notice how the blank row and column categories are replaced with the custom text "DESC". The buttons use the SETBLANKLABEL script internally.

SETBLANKLABEL function in action

Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON