PL-300: Microsoft Power BI Data Analyst
What allows users to jump to different report pages while simultaneously filtering based on the specific item selected?
Drill through filters
Tooltips
R visuals
Page filters
Answer is Drill through filters
Drill through filters allow users to jump to different report pages (like bookmarks), while simultaneously filtering based on the specific item selected
What do bookmarks accomplish in Power BI?
They save a query for use in other reports
They save a subsegment of your data table as a separate file
They save a pre-filtered view of your report
They save your chart as a template
Answer is They save a pre-filtered view of your report
Bookmarks allow you to create pre-filtered views of your reports, which you can then link to an object using it's action properties.
What type of visual interaction is shown in the map above?
Highlight
Bookmark
Drill through filter
Tooltip
Answer is Tooltip
Tooltips, like the one shown above, are a way to add additional data when you hover over a visual.
Which of the following actions requires you to be signed in to Power BI?
Importing custom visuals
Linking bookmarks
Editing report interactions
All of the above
Answer is Importing custom visuals
Importing custom visuals from files, your organization, or the AppSource marketplace requires you to sign in to Power BI.
Which of the following options is part of Power BI's accessibility features?
Themes
Layer order
Tab order
All of the above
Answer is All of the above
These are all part of Power BI's different accessibility features that allow consumers to easily navigate reports.
Which of the following objects cannot be pinned as an individual tile to a dashboard?
Filled Maps
Tables
Slicers
Bar Charts
Answer is Slicers
Slicers cannot be pinned to a dashboard individually, they need to be pinned as part of a live page.
Which of the following is a benefit of pinning a live page?
Slicers are imported
Functionality is preserved
Updates to the report are reflected
All of the above
Answer is All of the above
The Pin Live Page option pins an entire report to a dashboard while also importing slicers, preserving functionality, and reflecting any updates to the report.
You create a report in the Power BI service that displays the following visualizations:
- A KPI that displays the count of customers
- A table that displays the count of customers by country
- A line chart that displays the count of customers by year
You need to receive an alert when the total number of customers reaches 10,000.
What should you do first?
Pin the line chart to a dashboard.
Pin the KPI to a dashboard.
Embed the report into a Microsoft SharePoint page.
Pin the report to a dashboard.
Answer is Pin the KPI to a dashboard.
Alerts can only be set on tiles pinned from report visuals, and only on gauges, KPIs, and cards.
References:
https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
You have a sales report in an app workspace. The report displays a map of sales by location and a bar chart of sales by year. The report has a slicer to filter the data by year.
You need to create a dashboard that contains visualizations. The solution must ensure that you can use the slicer to filter the data by year.
What should you do?
Pin each visualization to the dashboard, and then add a web content tile.
Add a page level filter, and then pin each visualization to the dashboard.
Publish the app workspace.
Pin the report as a live page.
Answer is Pin the report as a live page.
References:
https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-live-tile-from-report
You create a report in the Power BI service.
You plan to provide external users with access to the report by publishing the report to a public blog.
You need to ensure that the report in the blog post will be updated as the data is refreshed.
What should you do in the Power BI service?
Publish the app workspace to the entire organization. In the blog post, use the URL of the workspace.
Share the report. In the blog post, use the URL of the dashboard.
Publish the report to the web. In the blog post, use the embed code URL.
In the blog post, use the URL of the report.
Answer is Publish the report to the web. In the blog post, use the embed code URL.
After you create your Publish to web embed code and share it, the report is updated with any changes you make, and the embed code link is immediately active. Anyone who opens the link can view it. After this initial action, however, updates to reports or visuals can take approximately one hour before becoming visible to your users.
References:
https://docs.microsoft.com/en-us/power-bi/service-publish-to-web