SEMANTICFORMAT

Semantic formatting lets you highlight or emphasize positive and negative values.

Syntax#

SETSEMANTICFORMATTING(VALUE)

Arguments#

VALUE - Pass a boolean value of TRUE or FALSE.

Example#

SETSEMANTICFORMATTING(TRUE)

SEMANTICFORMAT.POSTIVE.AFTER  // 123+
SEMANTICFORMAT.POSTIVE.BEFORE // +123
SEMANTICFORMAT.NEGATIVE.BRACKET //(123)

Notice how semantic formatting options have been applied in the reading view for positive and negative numbers using the SEMANTICFORMATTING functions.

Semantic formatting options

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