powerbi条件格式_PowerBI中的条件格式
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 bad on some pre-defined conditions on the values of a lected metric. It is mostly ud when the data is prented in a tabular format; however, it can also be ud 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 expresd 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.
当以表格格式表⽰的数据很多时，乍⼀看就很难理解哪个值更⾼或更低。 通常，您需要深⼊了解单元格
pray是什么意思值以了解或⽐较所显⽰的各种指标。
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 e 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 databa that is provided by Microsoft. You can this databa on your local easily. Since I have already installed the databa, I won’t be covering tho steps here. In order to import the data into Power, you can walk along with me in the steps bel
ow:
hardwareerror让我们⾸先尝试将⼀些数据导⼊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 rver name and the name of the databa and click OK
在出现的“连接服务器”对话框中，提供服务器名称和数据库名称，然后单击“ 确定”。
Figure 3 – Server Details
图3 –服务器详细信息
4. Connect using your credentials as required and click on Connect. In my ca, I’m using Windows Authentication mode
to connect to the databa in SQL Server
2011吉林高考分数线
根据需要使⽤您的凭据进⾏连接 ，然后单击“ 连接” 。 就我⽽⾔，我正在使⽤Windows⾝份验证模式连接到SQL Server中的数据
库
Figure 4 – Authentication
图4 –验证
5. Once you click on Connect, you’ll e that all the tables from the databa are listed in the dialog box. For this article,
we will just lect three of the tables – Dimensions.City, Dimensions.Date and Fact.Sale. Click Load once done:
研究生预报名和正式报名的区别单击“连接”后，您将看到对话框中列出了数据库中的所有表。 对于本⽂，我们将仅选择三个表– Dimensions.City ，
Dimensions.Date和Fact.Sale 。 单击完成后加载 ：
Figure 5 – Selecting Tables
图5 –选择表
6. All three tables will now be loaded into the Power BI data model and available on the data pane:
现在，所有三个表都将被加载到Power BI数据模型中，并在数据窗格中可⽤：
Figure 6 – Data Imported
公费研究生图6 –导⼊的数据
在Power BI中⽣成报告 (Building a report in Power BI)
Now, let us quickly build a Power BI report using the Matrix visualization. It will u the data from the tables that we just imported. Click on Matrix on the Visualizations pane and drag and drop the respective fields into the Rows, Columns and Values, as shown in the figures below:
现在，让我们使⽤Matrix可视化⼯具快速构建Power BI报告。 它将使⽤我们刚刚导⼊的表中的数据。 单击“ 可视化”窗格上的“ 矩阵”，然后将相应的字段拖放到“ ⾏” ，“ 列”和“ 值”中，如下图所⽰：
趋势英文
Once the fields are in place, you’ll e a similar kind of matrix being created in the Power BI report. This is a simple matrix that displays the sum of Total Including Tax for each of the Sales Territory and by Year. As you can e, it’s not easy to understand the highest and lowest values in the matrix; we need to dive deep into the visual and understand tho values.
字段到位后，您将在Power BI报表中看到正在创建的类似矩阵。 这是⼀个简单的矩阵，显⽰每个销售地区和按年份的总含税总额 。 如您所见，要了解矩阵中的最⼤值和最⼩值并不容易。 我们需要深⼊了解视觉并理解这些价值。
在Power BI中实施条件格式 (Implementing conditional formatting in Power BI)
In order to implement conditional formatting in Power BI, let us go ahead and define the rules for which we would like to visualize. Let us consider that we will change the background color of the cells bad on the values each cell holds. For instance, the cell with the lowest value will have a background color of red while the highest will be highlighted in blue. You can follow the steps below to implement the same.
为了在Power BI中实现条件格式设置，让我们继续并定义要可视化的规则。 让我们考虑我们将基于每个单元格所保存的值来更改单元格的背景⾊。 例如，具有最低值的单元格将具有红⾊的背景⾊，⽽具
有最⾼值的单元格将以蓝⾊突出显⽰。 您可以按照以下步骤实施。
1. Right-click on the “Total Including Tax” field in the Values ction
2. 右键单击“ 值”部分中的“ 含税总额 ”字段
3. Select Conditional Formatting and then click on the Background color
选择条件格式 ，然后单击背景⾊
