Segmenting Sales Data by State and City

Correct Answer: D

Power BI's Visualization panel provides access to the various data presentation tools, like bar and column charts, combo (a combination of line and bar charts), line, area, and pie charts.

You can also find scatter plots, cards (single number and multi-rows), KPI, Key influencers, maps, matrix, Q&A, tables, etc.

You can even add a Power Apps created for Power BI to your report.

If you need to segment data by a specific value or values, a slicer is the most powerful control to do that (Number 1)

You can select a visualization control, put it on a canvas and add the data.

In our case, we can add State and City data (Number 2).

Option A is incorrect because Treemap is a chart control with colored rectangles where the rectangle's size represents the value.

This control does not segment the report data by specific value.

Option B is incorrect because KPI is a visual control that presents progress to your goal, like the current amount of the raised funds against the goal in a fundraising event.

This control does not segment the report data by specific value.

Option C is incorrect because a Multi-row card is a visual control that presents a piece of information in several rows as a card.

This control does not segment the report data by specific value.

Option E is incorrect because Key Influencers is a visual control that helps you analyze the variations between data sets.

The control automatically creates the appropriate charts to illustrate the data variations and provides users tools for interactive data analysis.

This control does not segment the report data by specific value.

For more information about Power BI visualizations, please visit the below URLs:

The correct answer to the question is D. Slicer.

A slicer is a visual control that allows you to filter data in a report. In this case, you can use a slicer to segment sales data by State and City. The slicer can be used to filter data in a variety of ways, such as by date range, geographic location, or any other field in your dataset.

When you add a slicer to your report, you can choose which fields to use as the filter, such as the State and City fields in this case. Users can then use the slicer to select specific States and Cities to filter the data and see how sales are distributed across different locations.

Tree-map is a visual that displays hierarchical data as a set of nested rectangles, with the size of each rectangle proportional to the value of the data it represents. While this visualization could be used to display sales data by State and City, it may not be the most effective way to allow users to segment the data.

KPIs are visualizations that show progress toward a specific goal or target. While KPIs can be used to monitor sales performance against a target, they do not allow for segmentation of the data by State and City.

Multi-row card is a visual that displays multiple rows of data in a card format. While this visualization could be used to display sales data by State and City, it may not be the most effective way to allow users to segment the data.

Key influencers is a visual that uses machine learning to identify which factors have the most impact on a specific outcome. While this visualization can be useful for identifying the factors that are driving sales in different locations, it does not allow for segmentation of the data by State and City.

In summary, the most appropriate visualization to segment sales data by State and City in Power BI would be a slicer.