You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.
In powerbi.com, when users load the visual, they only see some of the customers.
What is the cause of the issue?
The visual was built by using a different version of R.
The data comes from a Microsoft SQL Server source.
The data is deduplicated.
Too many records were sent to the visual.
Answer is Too many records were sent to the visual.
R visuals in the Power BI service have a few limitations including:
- Data size limitations data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.
You have a report that contains four pages. Each page contains slicers for the same four fields.
Users report that when they select values in a slicer on one page, the selections are not persisted on other pages.
You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.
What are two possible recommendations to achieve this goal?
Replace the slicers with report-level filters.
Sync the slicers across the pages.
Create a bookmark for each slicer value.
Replace the slicers with page-level filters.
Replace the slicers with visual-level filters.
Answers are; Replace the slicers with report-level filters.
Sync the slicers across the pages.
A: Add a report-level filter to filter an entire report.
The visuals on the active page, and on all pages in the report, change to reflect the new filter.
B: You can sync a slicer and use it on any or all pages in a report.
1. On the Power BI Desktop View menu, select Sync slicers.
The Sync slicers pane appears between the Filters and Visualizations panes.
You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader.
You need to ensure that the users can consume the content on a report page in a logical order.
What should you configure in Microsoft Power BI Desktop?
the tab order
the layer order
the bookmark order
the X position
Answer is the tab order
If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.
You need to create a sales report in Power BI that meets the following requirements:
Must display data in tables with headers and footers
Must print all data in the report
Must allow users to select a region value in the parameters
What should you do?
Create a paginated report with a table.
Create a scorecard.
Create an interactive report with a matrix.
Create an interactive report with a table.
Answer is Create a paginated report with a table.
Question 225
Where are time series charts located?
The filter pane is where all filters on visuals and pages are located.
The fields pane is where all charts are located.
Time series charts can be imported from AppSource.
Answer is Time series charts can be imported from AppSource.
Question 226
What visual should be used to display outliers?
The line chart is best-suited to display outliers.
The clustered column chart is best-suited to display outliers.
The scatter chart displays outliers.
Answer is The scatter chart displays outliers.
Question 227
What does the AI splits feature do?
AI splits work by considering all available fields and determining which one to drill into to get the highest/lowest value of the measure that is being analyzed.
AI splits work by considering all available fields and determining which one to drill into and will only return the highest or lowest value within your dataset.
AI splits only display the difference between highest and lowest value of the measure that is being analyzed.
Answer is AI splits work by considering all the available fields and determining which one to drill into to get the highest/lowest value of a measure that is being analyzed.
Question 228
Can you access the Q&A feature by using buttons?
Yes, you can, but you will need to add the Q&A visual to your reporting canvas and then link your button with the visual that you have added.
Yes, you can access the Q&A feature by selecting the Q&A button type.
No, to use the Q&A feature, you will need to add the Q&A visual to your reporting canvas.
Answer is Yes, you can access the Q&A feature by selecting the Q&A button type.
Question 229
What is not a feature of the Q&A feature?
Searching for help topics about Power BI.
Adding new synonyms to fields through Q&A tooling.
Converting a Q&A answer into a visual inside your report.
Answer is Searching for help topics about Power BI.
Question 230
What does the decomposition tree not enable you to do?
Conduct root cause analysis to understand a measure better.
Conduct what-if analysis with built-in parameters.
Automatically analyze selected dimensions to find where a measure is highest or lowest.
Answer is Conduct what-if analysis with built-in parameters.