Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |