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!
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/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.