Home » Microsoft » DA-100 v.2 » What should you do?
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Add a salary to the tooltips.
B. Add a salary to the visual filters.
C. Add salary to the drillthrough fields.
Correct Answer: AB
Explanation/Reference:
Explanation:
A: When a visualization is created, the default tooltip displays the data point’s value and category. There are many instances when customizing the tooltip information is useful. Customizing tooltips provides additional context and information for users viewing the visual. Custom tooltips enable you to specify additional data points that display as part of the tooltip.
B: Visual Filter applies to a single visual/tile on a report page. You can only see visual level filters selected visual on the report canvas.
Note: This question currently requires two answers. Answer A is 100% correct. Answer B is not correct but it is the next best answer. Should this question should only require one answer, Answer A.
Incorrect Answers:
C: With drill through in Power BI reports, you can create a page in your report that focuses on a specific entity such as a supplier, customer, or manufacturer. When your report readers use drill through, they right-click a data point in other report pages, and drill through to the focused page to get details that are filtered to that context. You can also create a button that drills through to details when they click it.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips
https://technovids.com/power-bi-filters/
