如何在 Matrix Widget 中显示 AVG 值以及 Power BI 中的 Total [英] How to show AVG value in Matrix Widget along with Total in Power BI

问题描述

我在 Power BI 中使用 Matrix Widget，我在其中显示按日计数以及行的总和和列的总和，如下图所示.

I am using Matrix Widget in Power BI where I am showing day wise COUNT along with SUM of Row and SUM of Column as shown in the image below.

这里我想要的是与 Total 我需要显示 AVG 以及 Row 和 Column 明智，如下图所示

Here what I want is along with Total I need to show AVG as well both Row and Column wise as shown in image below

如何实现这一点，我尝试创建新的列和新的矩阵，但没有得到所需的输出.

How to achieve this, I tried creating new Column and new Matrix but not getting the desired output.

推荐答案

首先，在 Value 字段中添加与我在下图中标记的 1 和 2 相同的值列.我的情况是，我添加了两次 Sales 列，并为第二个选择了 Average 计算，如图所示-

First, add the same value column to the Value field as I marked 1 and2 2 in the below image. My case, I have added the column Sales twice and select the Average calculation for the second one as shown in the image-

现在，您将在每个日期获得 2 列 - Sales 和 Average of Sales 我的情况.在上图中，您只能看到日期 1 的 Average 列.这是因为我为其他列设置了宽度 0.对所有 Average... 列应用相同的值，输出将接近您的要求.

Now, You will get 2 column per date - Sales and Average of Sales my case. You can see only one Average column in the above image for date 1. This is because I have make width 0 for other columns. Apply the same for all Average... columns and the output will be close to your requirement.

这篇关于如何在 Matrix Widget 中显示 AVG 值以及 Power BI 中的 Total的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！