PowerBI 中 x 轴上的多列 [英] Multiple columns on x-axis in PowerBI

问题描述

我有一个看起来像这样的数据集

I have a dataset that looks like this

A1 - A15 均为正整数

All of A1 - A15 have positive integer values

我想要一个图表，x 轴上有 A1 - A15，Y 轴上有它们的值，CN 和 RN 作为过滤器.

I want a graph with A1 - A15 on the x-axis and their values on the Y-axis with CN and RN as filters.

我正在尝试创建条形图.我应该在 Axis、Value、Tooltips 等中输入什么内容.这是我第一次使用 PowerBI 之类的东西.

I am trying to create a bar chart. What should I be putting in Axis, Value, Tooltips, etc. This is my first time with anything like PowerBI.

推荐答案

如果你从看起来像这样的表格开始:

If you start with table that looks like this:

您可以选择 A1 到 A3 列，然后在查询编辑器中，使用 Transform > Unpivot Columns 获得如下所示的表:

You can select columns A1 through A3 and, in the query editor, use Transform > Unpivot Columns to get a table that looks like this:

一旦您以这种形式获得它，您就可以将 Attribute(列名称)放在 Axis 上，将 Value 列放在 Value 部分.

Once you have it in that form, you can put the Attribute (column names) on the Axis and the Value column in the Value section.

一旦你添加了 CN 和 RN 切片器，它应该是这样的:

Once you add the CN and RN slicers it should look like this:

这篇关于PowerBI 中 x 轴上的多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！