Data bars for one-click visual comparison with values hidden in a table column

Create reports

Answer Correct answer: C — data bars give proportional visual comparison for all values in one rule and can render without the numeric text.

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?

font color
icons
data bars Correct Answer
background color

data bars formatting conditional formatting hide values table

Community Votes

100%

100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Data bars render proportional bars per value with a single setting and can be shown without the number, satisfying visual comparison, per-value differentiation, hidden text, and minimal effort simultaneously.

A table column holds whole numbers from 1 to 20, and conditional formatting must let users compare values visually, differentiate every distinct value, hide the numeric text, and take minimal development effort.

Choosing icons for per-value differentiation — twenty distinct values would need twenty icon rules, exploding development effort, and icon sets still leave the numeric text unless separately hidden.

Community Discussion (10 comments)

jaume 👍 3 Selected: C

Agree with explanations from 539d541. Font color or background color options would result in a mess, difficult to identify all colors and since the goal is to compare values, how can you get which value is bigger from the color (only using kind of gradient, for 20 colors, not too much contrast) Icons allows to hide the numeric value but, again, 20 different icons and/or their colors would result in a very difficult exercise to compare 20 values (worst case, all differents). With data bars, even using one single color, would make easier to compare two different values in the table by comparing widths

LuluSkyy 👍 2

Was leaning between B and c. But i will go with C (Data Bars), this minimizes development efforts.

b92fc92 👍 2 Selected: C

C in my opinion

P_ri 👍 1

c. data bars

Ash_34 👍 4 Selected: C

It should be data bar. Key word is visually compare the values

SamiaAwais 👍 2 Selected: B

It should be Icons as you can hide the numeric value by adjusting the "Icon only" option, which removes the numbers and displays only the icons.

nelrosell 👍 1

B. Icons

539d541 👍 4 Selected: C

Disagree with using background color formatting. Data bars - option C would show a visual difference between each distinct integer for the range between 1 to 20. Can you imagine having 20 different background colors instead?

Endeetheanalyst 👍 1

B. Icons

Jayaruwan 👍 1 Selected: C

C. Data bars With background colors values cannot be given

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Expert Analysis

Why the Answer Is Correct

Data bars draw a bar whose length is proportional to the value behind each cell, giving instant visual comparison across the 1-20 range. The formatting is generated from the value distribution automatically — one rule covers all twenty distinct values, each getting a differently sized bar, which satisfies per-value differentiation without authoring per-value logic. Turning off the display of the value leaves only the bar, hiding the number, and the entire setup is one formatting choice, minimizing development effort.

Why the Other Options Are Wrong

Font color (A) or background color (D) with a gradient can differentiate values and be paired with hidden text, but comparing exact magnitudes by shade is far harder than comparing bar lengths, and neither reads as a visual comparison as directly as bars do. Icons (B) map value ranges to icons, but the requirement wants a different format for every one of twenty distinct values, which means up to twenty icon rules — maximum rather than minimal effort, and icons alone do not hide the number either.

Community Comment Notes

A commenter highlights the exact keywords: the requirement is to visually compare the values, which is what data bars are built for. Another comment notes they wavered between icons and data bars but settled on data bars because of the minimize-development-effort constraint.

Official Reference

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Related Analysis

Practice All PL-300 Questions

Access 116 questions with complete answers and detailed explanations.

View Full PL-300 Practice Test →

← Back to PL-300 Study Guide