ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam
Go to Exam

Exam DA-100 topic 3 question 17 discussion

Actual exam question from Microsoft's DA-100
Question #: 17
Topic #: 3
[All DA-100 Questions]

HOTSPOT -
You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.
The solution must use the existing calculations only.
How should you configure the visual? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Background color -
To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color.
In the Background color or Font color dialog box, select Field value from the Format by drop-down field.

Box 2: Field value -
With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
by brieucboonen1 at March 12, 2021, 10:37 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
brieucboonen1
Highly Voted 4 years, 3 months ago
Background color - by Rules isn't ?
upvoted 137 times
cufta05
3 years, 8 months ago
That's correct
upvoted 5 times
...
Zakriya
4 years, 1 month ago
Background color Rules
upvoted 34 times
...
Piiri565
4 years, 3 months ago
No, field values are used for conditional formatting, the given answer is correct, I have performed this
upvoted 17 times
Matreshka
3 years ago
Field value doesn`t perform with %Growth. Checked.
upvoted 1 times
...
adbukavu
3 years, 6 months ago
Field values only gives a gradual option. Rules you can define different colors for specfic intervals
upvoted 7 times
Soh_b
3 years, 5 months ago
yes correct, we have to select rules to have specific color based on value range
upvoted 2 times
...
...
manlynn
4 years, 2 months ago
Field value doesn't work without an additional column for the color. Tested in PBI. Correct answer should be Background color & Rules Ref:https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-based-on-a-calculation
upvoted 33 times
Georgerak
4 years, 2 months ago
When you have a field with the text "red" or "green" by selecting field it will color it red or green accordingly. Rules is the correct.
upvoted 8 times
kens09n
3 years, 12 months ago
Field Value will be based in a measure ex: if [% Growth to Last Year] >= 63%, "blue", "green")
upvoted 1 times
kens09n
3 years, 12 months ago
And there is this sentence in the question "The solution must use the existing calculations only." The only way to use a condition formatting using a calculation is thought Field Value
upvoted 3 times
...
...
...
...
Load full discussion...
...
...
VM_GCP
Highly Voted 4 years, 3 months ago
Background color Rules
upvoted 43 times
...
Michcat
Most Recent 2 years ago
Answer and Correct. To compare 2 columns, it needs to create a DAX column and assign color value. Then apply condiitional formatting --> field value base on this DAX column.
upvoted 1 times
...
Aibloy
2 years, 11 months ago
Rules: You need to specify the color for ranges manually as in Excel color formatting Field value: It have to take the specific output for the condition, for example, create a measure whose output is: "Green" or "Red" depending of previous conditions. We can't use more measures/columns Correct answer: Rules.
upvoted 2 times
...
Tomasz1989
3 years ago
"The solution must use the existing calculations only.' Therefore we cannot use Field Value
upvoted 1 times
...
Bhushan_M
3 years ago
Tested: Background Color and Rules
upvoted 2 times
...
NS1992
3 years ago
Background Color Rules
upvoted 1 times
...
zps55051
3 years, 2 months ago
the question doesnt make it clear if the measure's written to output colors or if rules were used.
upvoted 1 times
...
w0mz
3 years, 2 months ago
Answer: Background colour & Field value Fyi: Rules requires you to manually input conditions, whereas field value bases the conditions on another column as required in the question
upvoted 2 times
elainesoh123
3 years, 2 months ago
But what is the possible field condition on another column to result in the colors shown in the question? I would choose rules.
upvoted 1 times
...
...
Ashley090521
3 years, 3 months ago
on exam 3/1/2022
upvoted 2 times
...
James_8341
3 years, 3 months ago
background by rules "The solution must use the existing calculations only." means you cannot choose Fields value, which require an additional value field.
upvoted 4 times
...
Meyti
3 years, 5 months ago
Background color and Rules are correct. Tested
upvoted 3 times
...
Shan
3 years, 5 months ago
In exam 30/12/21
upvoted 1 times
...
kwanalytics
3 years, 5 months ago
On exam Dec. 27, 2021 - answered Background color & Rules
upvoted 3 times
...
kblee
3 years, 5 months ago
Backgorund color and Rule - Rule can set based on specific intervals
upvoted 1 times
...
Fuulhouse
3 years, 6 months ago
Background color & rules
upvoted 1 times
...
semwaja
3 years, 7 months ago
Background color and Rules. With Rules, you can define multiple ranges of values with colors of your choice.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel