In a table visual with three measures (Sales, Units, and Customers), which approach allows formatting logic to apply only to the Sales measure while preventing changes to the other two measures?

In a table visual with three measures (Sales, Units, and Customers), which approach allows formatting logic to apply only to the Sales measure while preventing changes to the other two measures?

• A. Dynamic measure formatting
• B. Static formatting with conditional formatting
• C. Slicer-based formatting
• D. Formatting done in a separate measure table

Answer: (A)

The idea being tested is that formatting can be bound to a specific measure so it follows that measure and doesn’t affect others. When you apply dynamic formatting to the Sales measure, you embed the display rules (such as currency, decimal places, or a custom format) directly with that measure. The table visual will then render Sales using its own format, while the Units and Customers measures keep their existing formats because their formatting is defined within their own measures. This isolated approach makes it possible to change how Sales looks without altering the formatting of the other two measures. Other approaches would either apply formatting rules at the visual level that could impact multiple fields, rely on slicers to drive formatting (which introduces user-driven changes that aren’t tied to a single measure), or require routing formatting through a separate table, which adds complexity and risk of affecting measures beyond the one intended. Dynamic formatting keeps formatting logic neatly contained with the Sales measure, ensuring the other two remain unchanged.

The idea being tested is that formatting can be bound to a specific measure so it follows that measure and doesn’t affect others. When you apply dynamic formatting to the Sales measure, you embed the display rules (such as currency, decimal places, or a custom format) directly with that measure. The table visual will then render Sales using its own format, while the Units and Customers measures keep their existing formats because their formatting is defined within their own measures. This isolated approach makes it possible to change how Sales looks without altering the formatting of the other two measures.

Other approaches would either apply formatting rules at the visual level that could impact multiple fields, rely on slicers to drive formatting (which introduces user-driven changes that aren’t tied to a single measure), or require routing formatting through a separate table, which adds complexity and risk of affecting measures beyond the one intended. Dynamic formatting keeps formatting logic neatly contained with the Sales measure, ensuring the other two remain unchanged.