Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 29
Read the below information and answer the questions that are part of the case study.
Below is the sample data of a popular affiliate marketer from India. The dataset contains information on the traffic (Clicks) and Affiliate Income (Sales Amount) he generates from different advertisers via his blog.
You have created two report pages in Power BI Desktop.
The report Clicks by Advertiser has:
· A column chart displaying the number of clicks for each Advertiser.
· An Affiliate Channel slicer.
· In addition, you added a Line chart that displays Clicks by Year
The report Sales by Advertiser has a bar chart displaying the Sales Amount for each Advertiser. There is also a Date slicer in this report.
What two actions would you perform to ensure that if a business user selects any date in the Date slicer, all visuals on the first report page, except the Line chart, are filtered?
Note: You have synced both the slicers.
-
A
Edit the interactions between the
Affiliate Channelslicer and the Line chart -
B
Copy, paste, and sync the Date slicer on the first report page
-
C
Edit the interactions between the Date slicer and the Line chart
-
D
Unhide the Date slicer
Reveal correct answers
Correct answers: C, D
Explanation
When you sync a slicer from one report page to a slicer on another page, Power BI places that slicer visual on the report page to which it syncs.
For example, when you sync both the Affiliate Channel and the Date slicer, Power BI places a Date slicer (on the first report page). And an Affiliate Channel slicer (on the second report page).
Open the Selection tab to view the added slicer, since it is hidden, by default.
Since a hidden Date slicer is already available (on the first report page), we
1) Unhide the Date slicer
2) Edit the interactions between the Date slicer and the Line chart
You can also hide the Date slicer again if you choose not to display it.
Now, if you select any date from the slicer (on the second report page), all visuals except the line chart are filtered.
Options Unhide the Date slicer and Edit the interactions between the Date slicer and the Line chart are the correct answer choices.
The option Copy, paste, and sync the Date slicer on the first report page is incorrect.
Since the slicers are already synced, if you copy, paste, and sync a Date slicer, there will be two Date slicers now.
1. One visible Date slicer from the copy-paste operation
2. And the other hidden Date slicer from the sync operation.
3. Even after you set Edit interactions to 'None,' selecting any date in the Date slicer filters the line chart.
So, copying and pasting the slicer will not work in this case.
It is easy to understand why. Just unhide the Date slicer (from the sync operation). Although we set edit interactions to 'None' for the Date slicer (from copy-paste), the other Date slicer still filters the line chart. And somehow, we can get the required result only if we set the edit interactions for all Date slicers to 'None.'
If you have already copy-pasted the Date slicer and still would like to see it work, do the following:
1. Unhide the Date slicer (from the sync operation)
2. Set the edit interactions for this Date slicer with the line chart also to 'None.'
Hide the Date slicer. Observe that the edit interactions work correctly and that the line chart is unfiltered.
Reference Links: https://community.powerbi.com/t5/Desktop/Edit-Interactions-menu-for-Sync-Slicers/m-p/377941 (directly refer to the solution).
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
