Exam PL-300 topic 3 question 71 discussion

I passed the exam today (948/1000). My answer was: - Configure the measure to use a custom format - For the visual, apply conditional formatting to the font color

B to format measure with parenthesis and decimals and c for configuring font color

1.Set values to two decimal places: To ensure all values have two decimal places, you can configure the visual by setting the "Value decimal places" to 2 under the Data label or Format pane. This is why D is correct. 2.Display negative values in red font and parentheses: To achieve this, you need to apply a custom format to the measure. A custom format string can be configured in the measure settings (e.g., #,##0.00;(#,##0.00)). #,##0.00;(#,##0.00): Formats positive numbers normally and displays negative numbers in red font with parentheses. This makes B correct.

Decimal is not conditional formatting

It's not enough set 2 decimal places as in option D as there is a requisite for negative values to be displayed in red font AND PARENTHESIS, that's the reason for the option B Requisite is red FONT color not the background color, therefore second solution is option C Requisite is red FONT color not the background color, therefore second solution is option C

B and C is correct.

BD With conditional formatting it is not possible to do the paranthesis. This is only possible with a custom format.

B & C is the correct answer as explained in this video : https://www.youtube.com/watch?v=zLG4fAHgkK4

Wrong answer given...should be B & D. There is no way to give parantheses for negative value by configuring the visual font format....has to be custom

BC is the correct answer

Tested - B and C is correct

GPT says: B & C.

FORMAT() will return a STRING, not number to use in visuals

the answers C and D could be correct if we dont need to add parentheses.

how to create a measure to set values to two decimal places?

Here is the code for custom measure for paranthesis Measure = var a =SUMX(FactInternetSales, FactInternetSales[DiscountAmount]-FactInternetSales[SalesAmount]) return format(a,"(#,##0.00)")

C is correct as shown in this video https://youtu.be/zLG4fAHgkK4 Once you have configured negative values, you need to apply font color. So B