Create Reports PL-300 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   Your organization has a standard corporate theme defined in a JSON file. You are creating a new report and want to ensure that all visuals use the corporate colors and fonts, but you also need to customize the background color of one specific page to match a client's branding. What is the most efficient approach?

   • AApply the corporate theme and then use a custom visual to cover the background of the specific page.
   • BApply the corporate JSON theme to the report, then change the page background color for that specific page.
   • CCreate a new JSON theme based on the corporate theme and modify the background color, then apply it to the report.
   • DManually set the colors of every visual on every page to match the corporate theme, and set the page background for the client page.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   A data analyst needs to show the proportion of total sales contributed by each product category. Which visual type is most appropriate?

   • AStacked column chart
   • BScatter chart
   • CLine chart
   • DPie chart
   Reveal Solution Discussion Select an answer first
4. 23expert · hard

   A data analyst has a Power BI report with a matrix showing monthly sales by product category. The analyst needs to add a visual calculation that shows the percentage change from the previous month for each category, without modifying the underlying data model. What should the analyst do?

   • ACreate a new measure in the data model using DAX and add it to the matrix.
   • BUse conditional formatting on the matrix to show percentage change.
   • CUse the visual calculations feature in the matrix to create a calculation that references PREVIOUS_MONTH.
   • DAdd a new column to the underlying table using DAX in Power Query.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   A report author wants to set the size of a report page to a specific dimension for printing. Where should this be configured?

   • AVisual formatting pane
   • BData model settings
   • CTheme settings
   • DPage setup in the report page settings
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A project manager has a Power BI report showing task status. They want to highlight tasks that are overdue (due date before today) in red and tasks due within the next 7 days in yellow. The report should be easy to update as dates change. What should you configure?

   • AConditional formatting on the due date field using rules that compare the date to TODAY().
   • BA calculated column that assigns a color code, then use that column in a legend.
   • CManual formatting of each task row based on the current date.
   • DA slicer that filters tasks by due date.
   Reveal Solution Discussion Select an answer first