power bi条件格式_Power BI中的条件格式

power bi条件格式

In this article, I’m going to explain what conditional formatting in Power BI is. Conditional formatting, as the name suggests, is a way of visualizing data that applies special format rules based on some pre-defined conditions on the values of a selected metric. It is mostly used when the data is presented in a tabular format; however, it can also be used in any charts such as bar charts, line charts, etc.

在本文中，我将解释Power BI中的条件格式是什么。 顾名思义，条件格式是一种可视化数据的方式，该数据基于对选定度量值的某些预定义条件应用特殊格式规则。 它主要用于以表格形式显示数据时使用。 但是，它也可以用于任何图表，例如条形图，折线图等。

Power BI中的条件格式是什么？ (What is conditional formatting in Power BI?)

When there is a lot of data expressed in tabular format, it becomes difficult to understand which of the values are higher or lower at first glance. Often, you need to eyeball deeply into the cell values to understand or compare various metrics that are being displayed.

当以表格格式表示的数据很多时，乍一看就很难理解哪个值更高或更低。 通常，您需要深入了解单元格值以了解或比较所显示的各种指标。

For instance, if you consider the figure on the left below, there is just too much data and you need to compare each of the cell values individually in order to understand more about it. However, if you see figure on the right, you can understand just by looking at a single glance, what are the higher values, the middle values and which values are lower. This is known as conditional formatting in Power BI.

例如，如果您考虑下面的左图，那么数据太多了，您需要分别比较每个单元格值以了解更多信息。 但是，如果您看到右侧的图，则只需看一眼就可以了解，什么是较高的值，中间的值以及哪些值较低。 这在Power BI中称为条件格式。

设定资料 (Setting up data)

Let us first try to import some data into the Power BI data model. Once the data is imported, we will investigate how to implement conditional formatting. For the sake of this article, I’m going to import the data from the famous WideWorldImportersDW database that is provided by Microsoft. You can download and install this database on your local easily. Since I have already installed the database, I won’t be covering those steps here. In order to import the data into Power, you can walk along with me in the steps below:

让我们首先尝试将一些数据导入Power BI数据模型。 导入数据后，我们将研究如何实现条件格式。 为了本文的目的，我将从Microsoft提供的著名的WideWorldImportersDW数据库中导入数据。 您可以轻松地在本地下载并安装此数据库。 由于我已经安装了数据库，因此这里不再赘述。 为了将数据导入Power，您可以按照以下步骤与我同行：

1. Get Data 获取数据”

2. Select SQL Server from the dropdown that appears

   从出现的下拉菜单中选择“ SQL Server ”

   

   Figure 2 – Get Data in Power BI

   图2 –在Power BI中获取数据

3. In the Connect Server dialog box that appears, provide the server name and the name of the database and click OK

   在出现的“连接服务器”对话框中，提供服务器名称和数据库名称，然后单击“ 确定”。 <