DISPLAY SETTINGS

Report authors can choose to give users access to certain display settings like ragged hierarchy, semantic formatting, and null/zero handling with scripts. When used with variables, users will be able to turn these settings on or off although they cannot directly access display settings.

NAMEDESCRIPTION
SETBLANKLABELReplace blank row or column categories with custom text.
SETSUPPRESSZEROSSuppress rows that contain only 0.
SETRAGGEDHIERARCHYHide blank categories when you have uneven/unbalanced hierarchical data.
SETCOMBINECOLUMNHEADERCombine the column headers and measure labels to display compact headers.
SETSEMANTICFORMATTINGSemantic formatting lets you highlight or emphasize positive and negative values.
SEPARATORSet custom delimiters for decimals and thousands.
SHOWNULLASCustomize how to display null values in your reports
SHOWZEROASCustomize how to display zeroes in your reports
SINGLECHILDSelect which nodes to display when a parent hierarchy has only one child.
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON