DRAG DROP - (Topic 4)
You plan to use Power BI to create a quarterly profit report that meets the following requirements:
• Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage
• Compares profit margins across sales regions
Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Topic 4)
You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart. You need to ensure that bar chart displays on Dashboard1. What should you do?
Correct Answer:
C
- (Topic 4)
You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
You need to ensure that User sees App1 from the My organization AppSource. What should you do?
Correct Answer:
C
References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource
HOTSPOT - (Topic 4)
You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Topic 1)
You need to address the data concerns before creating the data model. What should you do in Power Query Editor?
Correct Answer:
C
