El gráfico de columnas agrupadas de Power BI se usa para mostrar bars verticales de varias regiones de datos (medidas) en una única métrica. Permítame mostrarle cómo crear un gráfico de columnas agrupadas en Power BI con un ejemplo.
For this Power BI clustered column chart demo, we will use the SQL data source that we created in our previous article. So, check out the article Connect Power BI to SQL Server to understand the data source in Power BI.
How to create a clustered column chart in Power BI
First, click on the clustered column chart below the Display section. It will automatically create a clustered column chart with dummy data, as shown in the following screenshot.
<>To add data to the Power BI clustered column chart, we have to add the required fields:
- Axis: Specify the main column that represents the vertical axis.
- Legend: Specify the second column that represents vertical bars (or bar colors).
- Values: Any numerical value such as sales amount, total sales, etc.
Let me drag the Sales Amount section from the fields to the Values field
Next, let me add the English country region name to the Axis section to create a column chart. This chart shows the sales amount by country region name in English.
Then add English Occupation from the DimCustomer table to the Legend section.
Create a Clustered Column Chart Approach 2
To create a clustered column chart, first drag and drop the Sales Amount section of the fields to the region of the canvas. You'll create a column chart, as shown below.
Next, let me add the name of the English country region to the Axis section and the English occupation to the Legend section. Automatically creates a clustered column chart using the country and occupation columns for you.
Desplácese sobre cualquier barra vertical le mostrará la información sobre herramientas del nombre del país, la ocupación del client y el monto de ventas
Let me apply a quick format to this Power BI clustered column chart.
NOTE: The formatting options for the column chart and the clustered column chart are the same. Therefore, I suggest that you refer to the article Formatting Column Chart to understand the steps required to format clustered columns.
