英文:
Power BI - Show hierarchical/grouping data
问题
我想查看在Power BI中是否有可能有一个小部件，显示一行中的“常见”数据，然后在其他行中显示“区分”数据。
例如，假设我想显示一份电视节目清单。在每个电视节目下面，我想显示关于每个季节的数据。因此，数据可能如下（我没有填写所有数据，只是为了展示一个示例）：
| 电视节目标题 | 播放频道 | 类型 | 季节数 | 季首播集标题 |
|---|---|---|---|---|
| 绅士迷 | AMC | 时代剧 | 1 | 迷烟四溅 |
| 绅士迷 | AMC | 时代剧 | 2 | 为那些年轻人而战 |
| 权力的游戏 | HBO | 奇幻 | 1 | 冰与火降生 |
| 权力的游戏 | HBO | 奇幻 | 2 | 北国记忆 |
我想显示类似这样的数据：
| 电视节目标题 | 播放频道 | 类型 | 季节数 | 季首播集标题 | |
|---|---|---|---|---|---|
| +/- | 绅士迷 | AMC | 时代剧 | ||
| 1 | 迷烟四溅 | ||||
| 2 | 为那些年轻人而战 | ||||
| +/- | 权力的游戏 | HBO | 奇幻 | ||
| 1 | 冰与火降生 | ||||
| 2 | 北国记忆 |
起初，我以为可以使用矩阵，但它似乎不按我希望的方式工作。
有什么建议吗？
英文:
I'm looking to see if it's possible in Power BI to have a widget that shows "common" data in one row, then "differentiating" data below it in other rows.
For example, let's say I want to show a list of TV shows. And below each TV show, I want to show data about each season. So data might look like (I'm not filling out all of the data, just enough to show an example):
| TV Show Title | Broadcaster | Genre | Season # | Season Premiere Episode Title |
|---|---|---|---|---|
| Mad Men | AMC | Period Drama | 1 | Smoke Gets in Your Eyes |
| Mad Men | AMC | Period Drama | 2 | For Those Who Think Young |
| Game of Thrones | HBO | Fantasy | 1 | Winter is Coming |
| Game of Thrones | HBO | Fantasy | 2 | The North Remembers |
I want to show the data that looks kind of like this:
| TV Show Title | Broadcaster | Genre | Season # | Season Premiere Episode Title | |
|---|---|---|---|---|---|
| +/- | Mad Men | AMC | Period Drama | ||
| 1 | Smoke Gets in Your Eyes | ||||
| 2 | For Those Who Think Young | ||||
| +/- | Game of Thrones | HBO | Fantasy | ||
| 1 | Winter is Coming | ||||
| 2 | The North Remembers |
At first I thought I could use a matrix, but it doesn't seem to work that way I hoped.
Suggestions?
答案1
得分: 1
像这样？
如果是这样的话，请在选项中关闭阶梯布局。
我的数据看起来像这样
英文:
Like this?
If so, turn stepped layout off in the options.
My data looks like this
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论