mekko 教程_Power BI桌面Mekko图表

mekko 教程

In my last articles on Power BI Desktop (see the index at the bottom of the article), we have explored that Power BI has a rich set of visualizations. We can present data using various custom visuals available from Microsoft AppSource. These visuals are available free to download and use it as per our requirements.

在有关Power BI Desktop的最后几篇文章中（请参阅文章底部的索引），我们探索了Power BI具有丰富的可视化集。 我们可以使用Microsoft AppSource提供的各种自定义视觉效果来呈现数据。 这些视觉效果可根据我们的要求免费下载和使用。

Some of the articles for references are:

一些供参考的文章是：

• Word Cloud 词云
• Pulse Charts 脉搏图
• Interactive chord diagrams 互动和弦图

Note: You should have Power BI Desktop installed in order to use the custom Visuals along with a work account to download them from Microsoft AppSource.

注意：您应该已安装Power BI Desktop，以便与工作帐户一起使用自定义Visuals从Microsoft AppSource下载它们。

Normally we use stacked bar charts in Excel to analyze the data in excel with the help of 100% Stacked Column Charts as shown below.

通常，我们在Excel中使用堆积条形图借助100％堆积柱形图来分析excel中的数据，如下所示。

There is another way to represent data in terms of the stacked bar chart as shown below.

还有另一种以堆积条形图表示数据的方式，如下所示。

In the stacked chart, as shown here, the length or width of the bar shows the particular category data. It helps to analyze the data from a single category perspective but if we want to add more categories into the chart, it would be difficult to get these from the stacked charts.

在堆叠的图表中，如此处所示，条的长度或宽度显示了特定的类别数据。 它有助于从单个类别的角度分析数据，但是如果我们想在图表中添加更多类别，则很难从堆叠的图表中获取这些类别。

Power BI presents a unique way to represent data into a two-dimensional stacked chart called Mekko charts aka Marimekko Charts. In Mekko Charts both x and y-axis represent a percentage scale. This percentage scale represents both height and width of the segment. The column width of each segment is scaled so that total width matches the chart width. Therefore, Mekko charts are two way 100% stacked charts.

Power BI提供了一种独特的方式来将数据表示为称为Mekko图又称为Marimekko图的二维堆叠图。 在Mekko图表中，x轴和y轴均表示百分比刻度。 该百分比比例代表该段的高度和宽度。 缩放每个段的列宽，以便总宽度与图表宽度匹配。 因此，Mekko图表是两种100％堆叠图表。

将数据导入Power BI Desktop (Import Data into Power BI Desktop)

Let us first prepare the sample data for creating the Mekko Chart. We will prepare both the 100% stacked charts and Mekko Charts to see the difference in both the charts.

让我们首先准备用于创建Mekko图表的样本数据。 我们将准备100％堆叠图表和Mekko图表，以查看两个图表之间的差异。

In this example, let us import data from the source as an Excel file. Therefore, to import the data follow the steps below

在此示例中，让我们从源导入数据作为Excel文件。 因此，要导入数据，请按照以下步骤操作

Click on Get Data -> Excel Data Source

单击获取数据-> Excel数据源

Go the Excel file to import data into Power BI Desktop

转到Excel文件以将数据导入Power BI Desktop

We can view sample data as shown below

我们可以查看示例数据，如下所示