exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 73 discussion

Actual exam question from Microsoft's PL-300
Question #: 73
Topic #: 3
[All PL-300 Questions]

HOTSPOT
-

You have a Power BI report that contains a page. The page contains the following visuals:

• A card
• A matrix
• A bar chart

You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix. The card and the bar chart must change when a user selects a cell in the matrix.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
pverde
Highly Voted 1 year, 8 months ago
I would choose: Matrix Apply drill down filters to Selected Visual https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#change-the-interactions-of-drillable-visualizations By default, a matrix will have "Entire Page" in the "Apply drill down filters to" option inside the Format tab, which is what we don't want to happen, so changing to "Selected Visual" should give us the behavior we want
upvoted 59 times
Aldeus
1 year, 3 months ago
Right answer but you are wrong, by default drill down filters are set to Selected Visual: "For both Power BI Desktop and Power BI service, certain Power BI visualizations can be drilled. By default, when you drill a visualization, it has no impact on the other visualizations on the report page. However, that behavior can be changed."
upvoted 4 times
...
1763ab5
9 months, 3 weeks ago
Great, it tested. thanks a lot
upvoted 2 times
...
0a58a92
1 year, 5 months ago
pverde is right, i tested, if Apply drill down filters to Entire page, when i drill down on one visual, other visuals on the page will be filtered as well
upvoted 6 times
...
vidyaavs
1 year, 6 months ago
Drilling down should not affect the other charts as per the question. So shouldn't be Edit Interactions to filter?
upvoted 12 times
anormalhuman
1 year, 2 months ago
Correct. Visuals with drill down by default do not affect other visuals when drilling down- you have to tell them to specifically.
upvoted 7 times
...
IrynaVilner
1 year, 5 months ago
Agree with you. I just tested: 1. Matrix 2. Edit interactions to filter
upvoted 10 times
...
...
...
sankeytm
Highly Voted 1 year, 6 months ago
Shouldn't the answer be Matrix and Edit Interactions to Filter?
upvoted 23 times
IrynaVilner
1 year, 5 months ago
Yes, that's correct
upvoted 3 times
...
deyoz
1 year, 4 months ago
I think so. Default interaction settings of matrix visual with other visual is drill-down---> no change, and click ---> highlight. So, just need to change the setting to filter. therefore, Matrix, and filter are correct.
upvoted 1 times
...
...
jaume
Most Recent 5 months ago
I tested by default, having a card, a bar chart and a matrix in page, when a matrix cell is selected, card is filtered and matrix selection is highlighted in the bar chart and drilling down the matrix is also drilling down the chart and th bar chart. To disable the drill down over the bar chart and the card, we need to "apply drill down filters to selected visual". This option is not in the visual but in the "Format" section in the upper ribbon of the report. Turning this option from "Entire page" to "selected visual" we can limit the drill down effect to the matrix visual Note thar requisite it "….must change when a user selects a cell in the matrix" so it doesn't need to be the "filter change" but default highlight change" is fulfilling
upvoted 4 times
...
patrup
7 months, 3 weeks ago
I created a report from the financials sample with the respective visuals. With the matrix visual selected you go to the Format tab and turn "Edit Interactions" on. Then you set the interactions on the Card and the Chart to Filter, which will give you the desired result.
upvoted 1 times
...
rcaliandro
8 months, 1 week ago
No guys why drill down filters? In my opinion the given answer is correct
upvoted 1 times
...
991b9dd
10 months, 2 weeks ago
1. Matrix 2. Edit interactions to filter
upvoted 5 times
...
HenryBiz
11 months, 1 week ago
Agree with pvierde. I built a file and tested it.
upvoted 1 times
...
JudT
1 year ago
Tested - The correct answer is Matrix and Edit Interactions filter PS: "The card and the bar chart must change when a user selects a cell in the matrix" So Apply drill down filters to Entire page or Selected visual doesn't make any difference!
upvoted 7 times
...
GowthamMupparapu
1 year, 1 month ago
The answer should be Matrix Edit Interactions to filter I feel Apply drill down filters to selected visual is wrong as, our core intention is that there should be interactions/changs when something in matrix is selected.
upvoted 2 times
...
28485e1
1 year, 1 month ago
GPT says it's edit interactions to filter.
upvoted 3 times
...
fbbucky
1 year, 4 months ago
Just tested it using the sample given in the article below. I believe the answer is: Matrix Apply drill down filters to selected visual The tricky part about this question is that when you are drilling down, you have to turn on drill mode on. If you select any columns/cells it will not affect any other visual (this is a drill through filter that the question wants not to affect other visuals. But the question says also it must change the other visual when you select a cell. So then, if you turn off the drill mode off and then select a cell, it will cross highlight/filter the other visuals depending on the interaction settings. I hope it helps! https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop
upvoted 2 times
0e18c76
11 months, 3 weeks ago
No, no, no! Guys check the requirements and then pay close attention to the answer area. The configuration must be done on the visual type selected - "visual type" and then "Set" configuration. In this case, everybody agrees that the visual type should be the Matrix. Right! Then, we should set/configure "Apply drill down filter", on the matrix. Actually, we are just informed that the card and bar chart must change, when selecting a cell in the matrix. We were not asked to change the interaction of the existing interaction to filter. Have in mind that by default, the interaction is set on the bar and pie chart to highlight. Therefore: - Matrix - Apply drill down filter (this will not affect other visuals)
upvoted 2 times
...
deyoz
1 year, 4 months ago
default interaction of matix visual on other visuals is drill ---> no change, click in cell, highlight.
upvoted 3 times
...
...
Houassa
1 year, 5 months ago
Agreed with pverde : Matrix and Apply drill down filters to Selected Visual https://www.youtube.com/watch?v=a8r7c9NnLFY
upvoted 5 times
...
jl234
1 year, 6 months ago
Setting the interaction to "none" for the card and bar chart visuals will make sure they are not affected by drill-down actions in the matrix, but they will still respond to selections made within the matrix. This configuration allows users to explore data in the matrix by drilling down while keeping the card and bar chart visuals stable unless they make explicit selections within the matrix.
upvoted 1 times
...
lmrod
1 year, 8 months ago
This sentence makes me doubt: "The card and the bar chart must change when a user selects a cell in the matrix" If a cell in the matrix has to modify (I understand "filter") card and bar chart, don't we have to apply "Edit interactions to Filter"??
upvoted 5 times
JudT
1 year ago
Tested - The correct answer is Matrix and Edit Interactions filter PS: "The card and the bar chart must change when a user selects a cell in the matrix" So Apply drill down filters to Entire page or Selected visual doesn't make any difference!
upvoted 2 times
...
...
want2clear
1 year, 8 months ago
I changed my mind,pverde is right.
upvoted 1 times
...
want2clear
1 year, 8 months ago
i agree with selected Answer
upvoted 2 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago