Microsoft Power BI Data Analyst — Question 88

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?

Answer options

• A. font color
• B. icons
• C. data bars
• D. background color

Correct answer: C

Explanation

Using data bars (option C) allows for a visual representation of the values while hiding the actual numbers, fulfilling all the requirements effectively. Font color (option A) and background color (option D) do not provide distinct visual comparison for each unique number, and icons (option B) would not meet the requirement to conceal the numeric value.