PL-300 Question #425: Real Exam Question with Answer & Explanation

Question

You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional formatting to meet the following requirements: - Visually compare the values without having to read the text containing the number. - Show a different format for each distinct value. - Hide the numeric value of ColumnA. - Minimize development effort. Which formatting should you use?

Options

• Afont color
• Bicons
• Cdata bars
• Dbackground color

Explanation

To visually compare numeric values (1-20), show distinct formats, hide the numbers, and minimize effort, data bars are the ideal conditional formatting choice in Power BI.

Common mistakes.

• A. Font color would require defining 20 distinct colors and would not inherently hide the numeric value or provide a clear visual comparison of magnitude as effectively as data bars.
• B. Icons are typically used for thresholding or categorization and would require complex rules to show a different icon for each of 20 distinct values, making it high effort and potentially visually cluttered.
• D. Background color would suffer from the same issues as font color, requiring many distinct colors and not inherently hiding the numeric value for magnitude comparison as efficiently as data bars.

Concept tested. Power BI conditional formatting (data bars)

Reference. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-format-visual-elements#data-bars

No community discussion yet for this question.