Combining Summary and Detailed set

[Anonymous]

New to PB, please point me to the right direction. 

Have 2 separate data sets (below)  - Summary and Detailed.

Final goal - display it as Summary and give user ability to click on the product to get to the detailed set + apply multiple filters (i.e. date etc) 

What is the best way of doing it? Thanks!

Summary

Product	Total qty sold	Total avg price	Promo Start date	Promo End Date
111	15	$3	Jan 01 2020	Jan 10 2020
222	200	$10	Jan 2 2020	Feb 4 2020

Detailed

Product	Store#	qty sold	avg price	Promo Start date	Promo End Date
111	1	3	$2	Jan 01 2020	Jan 10 2020
111	2	10	$3	Jan 01 2020	Jan 10 2020
111	3	2	$4	Jan 01 2020	Jan 10 2020
222	1	100	$7	Jan 2 2020	Feb 4 2020
222	4	80	$20	Jan 2 2020	Feb 4 2020
222	5	20	$5	Jan 2 2020	Feb 4 2020

[Greg_Deckler · Accepted solution]

I would use a Matrix visualization with a row hiearchy of Product and Store or use drill through to a separate page.

I see you are a new member so if that doesn't help, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.