i
2 TopicsCombining 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 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 2020Solved814Views0likes1Commentpaginated report filter by sellers
Hi ! I'm new to this and face some difficulties with the paginated report builder. I created my different tables thanks to their DAX queries exported from PBI which traduce activities of my sellers. They each have a column with the "seller_name", and I'd like to create a report which present my tables but filtered for each sellers one after another so I can send it to them personnaly. Is it possible ? I created a parameter but it seems not to filter right the tables... Can someone please help me 😞 ? Thank you !489Views0likes0Comments