cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Combining Summary and Detailed set

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 soldTotal avg pricePromo Start datePromo End Date
11115$3Jan 01 2020Jan 10 2020
222200$10Jan 2 2020Feb 4 2020

 

Detailed

Product Store#qty soldavg pricePromo Start datePromo End Date
11113$2Jan 01 2020Jan 10 2020
111210$3Jan 01 2020Jan 10 2020
11132$4Jan 01 2020Jan 10 2020
2221100$7Jan 2 2020Feb 4 2020
222480$20Jan 2 2020Feb 4 2020
222520$5Jan 2 2020Feb 4 2020



1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.