You plan to develop a Power BI report that has a bar chart to display the number of customers by location. You have a table named Customer that has the following columns: - Customer ID…

Question

Options

• AIn the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
• BIn the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
• CIn the Axis field, add Country at the top, followed by ProvState, and then City.
• DIn the Value field, add Country at the top, followed by ProvState, and then City.

• A
  4% (2)
• B
  8% (4)
• C
  87% (45)
• D
  2% (1)

Explanation

In Power BI bar charts, drill-down hierarchies are defined in the Axis field. To drill from Country down to ProvState and then to City, you add all three fields to the Axis bucket in order: Country at the top, then ProvState, then City. Power BI reads the Axis hierarchy top-to-bottom as the drill-down sequence, so users can click the drill-down arrow to navigate from Country → ProvState → City. The Values field holds the measure (count of customers), not the geographic hierarchy. Adding fields to the Legend field creates a color-coded breakdown, not a drill-down path.

No community discussion yet for this question.