Hello, I am a very new user to Power BI and I have been unsuccessfully trying to create a new dashboard for my team. I am pulling in sales data across a couple of months for multiple products, and would like to have each unique product's performance over time broken out over individual line charts. I understand that you can display each product one at a time on one chart, or create multiple charts and set each chart to an individual product, but is there a way to do this automatically?
The reason is that sometimes I pull in 5 products, sometimes 7, etc. The number of products can change, so I was hoping that I could set a visual to create the correct number of individual line charts automatically, regardless of number of unique products. So if I pull in 3 products, 3 line charts are created, one for each product. If I pull in 6, 6 line charts are created, etc.
Hopefully that makes sense! Not sure if it is possible, but it would be very helpful if it is.
