Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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 |
Solved! Go to 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.
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.
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 |