QuestionQ82

Implement and manage semantic models

You have a Microsoft Power BI semantic model containing one table named Orders. Orders includes the following columns:

  • Product Name
  • Order Date
  • Quantity

You have a Power BI report with a page named Inventory. Inventory includes a slicer for the Product Name column and a clustered column chart that displays Quantity by Order Date.

You need to ensure that users can choose whether the chart displays Quantity by Product Name or Quantity by Order Date. The solution must minimize development effort.

What should you create?

  • A a measure
  • B a dynamic format sting
  • C a field parameter
  • D a calculation group
Explanation

A field parameter can contain both Product Name and Order Date and be placed in the chart’s axis field well. Its parameter slicer lets report users dynamically change the dimension analyzed by the visual, while Quantity remains the value.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!