Microsoft
70-778 · Question #76
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: CustomerID CustomerName…
The correct answer is D. In the Axis field, add Country at the top, followed by ProvState, and then City. https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18 https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down
Model and Visualize Data by Using Power BI Desktop
Question
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: CustomerID CustomerName Address City ProvState Country You need to allow users to drill down by location. The report will display the number of each customer by Country, and drill down to ProvState, and then to City. How should you configure the drill down in the bar chart?
Options
- AIn the Legend field, add Country. In the Axis field, add ProvState at the top, followed by City.
- BIn the Value field, add Country at the top, followed by ProvState, and then City.
- CIn the Value field, add Country. In the Legend field, add ProvState at the top, followed by City.
- DIn the Axis field, add Country at the top, followed by ProvState, and then City.
How the community answered
(38 responses)- A3% (1)
- B5% (2)
- C11% (4)
- D82% (31)
Explanation
https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations#step-18 https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down
Topics
#drill down#hierarchy#bar chart axis#location hierarchy
Community Discussion
No community discussion yet for this question.