Learn how to use conditional formatting in Power BI to visually compare distinct numeric values in a table column without showing the numbers. The best approach minimizes development effort.
Table of Contents
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?
A. font color
B. icons
C. data bars
D. background color
Answer
To meet all the requirements with minimal effort, the best formatting option to use is:
B. icons
Explanation
Icons allow you to visually compare the distinct values in the column without having to read the actual numbers. By choosing a different icon for each number from 1 to 20, you can easily differentiate between the values.
Icons also let you hide the underlying numeric value in the column. The icon serves as a visual representation of the number without needing to display the digit itself.
Using icons is a quick and easy way to apply the needed conditional formatting. It requires less development effort than manually setting different font colors, background colors, or data bars for each distinct value from 1 to 20.
Therefore, using icon sets is the optimal formatting choice for this scenario. It allows visual comparison of distinct values, hides the numbers, and minimizes the work required to implement the solution.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.