Multi-level/Nested table from Direct Query data

[Anonymous]

Hi, so I'm in the process of migrating some reports into PowerBI from another system, and need some help to recreate the report in PowerBI (or something close enough to it). In essence, what I want to create is like below image, where there is a multi-level/nested table (not really sure what to call it). The data is retrieved from a database View using a Direct Query and would look something like below. 

Data-example:

site_id	site_name	region	country	service_id	product	case_no	case_title	case_type
12345	My site	Stockholm	Sweden	Service 1	Product 1	11111	Case 1	support
54321	Other site	Oslo	Norway	Service 2	Product 2	22222	Case 2	support
54321	Other site	Oslo	Norway	Service 3	Product 3	33333	Case 3	support
54321	Other site	Oslo	Norway	Service 3	Product 3	44444	Case 4	support
...	...	...	...	...	...	...	...	...

Desired end-result:

As per request, here's a simple (graphically rough) result using above data. Note that the table is entirely manual to show the basic structure I'm after

Basically, a Site has at least one Service which in turn can have many Cases, so there's a couple of groupings to be done. 

Making just a simple table that looks essentially like the raw data is easy enough, but I'd like to keep the visuals of the old report as much as possible (users hate change and all that). 

I'm a complete rookie in PowerBI so I'm not really familiar with what visualizations would be applicable, and how to potentially restructure the data, so if you can point me towards some relevant docs/guides, or even provide a potential solution directly, that would be fantastic, but will take anything I can get!

[v-zhangti · Accepted solution]

Hi, @Anonymous 

There is currently no view that directly fits your expectations. But you can try the following methods.

Does this meet your desired outcome?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dhacd]

Hi 

By using the data example that you have given, 
Can you create a sample output in Microsoft Excel and share a screen snap so that we can have a better understanding.

Regards,

Atma.

[Anonymous]

I've added a screenshot of the rough structure I'm after. Hopefully it makes it a bit clearer