nerdexam
Microsoft

DP-500 · Question #43

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who…

The correct answer is C. Change the icons to use a different shape for each color. To make a table with conditional formatting accessible to users with color vision deficiency, you should change the icons to use a different shape for each color, providing a non-color-dependent differentiator.

Explore and visualize data

Question

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

Options

  • AAdd alt text to explain the information that each color conveys.
  • BMove the conditional formatting icons to a tooltip report.
  • CChange the icons to use a different shape for each color.
  • DRemove the icons and use red, yellow, and green background colors instead.

How the community answered

(45 responses)
  • A
    4% (2)
  • B
    7% (3)
  • C
    76% (34)
  • D
    13% (6)

Why each option

To make a table with conditional formatting accessible to users with color vision deficiency, you should change the icons to use a different shape for each color, providing a non-color-dependent differentiator.

AAdd alt text to explain the information that each color conveys.

While alt text is important for screen readers, it does not directly address the visual challenge of distinguishing colors for users with color vision deficiency when they are actively looking at the visual.

BMove the conditional formatting icons to a tooltip report.

Moving conditional formatting icons to a tooltip would hide the information by default, making it less accessible and requiring an extra step to view, which is not an improvement for accessibility.

CChange the icons to use a different shape for each color.Correct

For users with color vision deficiency, relying solely on color to convey information is problematic. By changing the icons to use a different shape for each color (e.g., triangle for below, circle for near, square for above), you provide an alternative visual cue that does not depend on color perception, thereby significantly improving accessibility.

DRemove the icons and use red, yellow, and green background colors instead.

Removing icons and using only background colors would worsen accessibility for users with color vision deficiency, as it eliminates any non-color visual cues and relies entirely on color.

Concept tested: Power BI report accessibility - conditional formatting

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessible-reports-design#colors-and-high-contrast

Topics

#Accessibility#Conditional Formatting#Data Visualization#Report Design

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice