user1795832
user1795832

Reputation: 2160

Power BI - Show hierarchical/grouping data

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

Answers (1)

davidebacci
davidebacci

Reputation: 30174

Like this?

enter image description here

enter image description here

If so, turn stepped layout off in the options.

enter image description here

My data looks like this

enter image description here

enter image description here

Upvotes: 1

Related Questions