Reputation: 2160
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?
Upvotes: 0
Views: 91
Reputation: 30174
Like this?
If so, turn stepped layout off in the options.
My data looks like this
Upvotes: 1