Power BI:使表格可视化显示数据集的所有观察结果 [英] Power BI: Make a Table Visualization display all observations of a dataset

问题描述

我注意到，如果您在 Power BI 桌面的数据查看器中有一个表，例如:

然后，如果您在表格可视化中插入同一个表格，该表格将只显示类别的不同值:

如何设置表格可视化，以便数据在显示所有观察的数据查看器中显示?

解决方案

遗憾的是，Power Bi Desktop 目前没有在表可视化(2018 年 10 月)中显示所有观察值的选项.我很乐观 Power Bi 团队会在未来的版本中解决这个问题.如果您对此功能有强烈的感觉，请转到

然后 - 返回您的报告，将索引列添加到表格可视化中，并确保为索引列值选项卡下拉选择不汇总.

将索引列添加到您的表格后，您按索引排序后，您的表格可视化效果应如下所示:

最后一步是通过缩小索引列的列宽来隐藏索引列.在执行此操作之前，您需要关闭列和值的自动换行.转到油漆滚筒并在列标题和值中确保关闭自动换行:

那么您的最终表格将如下所示，其中包含所需的所有值.灰色框是我的鼠标悬停在缩小的索引列上，除非您将鼠标悬停在该区域上，否则不会显示:

I've noticed that If you have a table in the Data Viewer in Power BI desktop such as this:

Then, if you insert the same table in a Table Visualization, the table will only display distinct values of the categories:

How can you set up a Table Visualization so that the data is displayed as it is in the Data Viewer where all observations are displayed?

解决方案

Unfortunately, Power Bi Desktop currently does not have an option to display all observations in the Table Visualization(Oct 2018). I am optimistic the Power Bi team will correct this problem in a future release. If you feel strongly about this feature, please go to the Power Bi improvement Idea post and add your vote.

I'm answering this question to perhaps help others who come here looking for a work around until it gets implemented.

There is currently one work around that I know of: Add an index column to the data table, add this column to your table visualization, then shrink the column width of the index to hide the data. This is not a desirable work around, but might get you a solution in a pinch until the feature is implemented.

So for your example, to add an index column to your table, go to Edit Queries -> Add Column -> Index Column -> From 1

Then - back to your report, add the Index column to the Table Visualization and make sure you select Don't Summarize for the Index Column values tab pull down.

Once the index column is added to your table, and you sort by the index your table visualization should look like the following:

The last step is to hide the index column by shrinking the column width of the index column. Before you do this, you need to turn off word wrap for the columns and the values. Go to the paint roller and in Column Header and Values make sure you turn word wrap off:

then your final table will look like the following with all of the values required. The grey box is my mouse over the shrunk index column and wont show up for you unless you mouse over that area:

这篇关于Power BI:使表格可视化显示数据集的所有观察结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！