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.
I upload dataset with:
- product's names at columns,
- dates at row,
- sales in cell.
And I want to do bar chart when you click to column, you get at line chart sales per day.I find info here https://powerbi.microsoft.com/en-us/documentation/powerbi-service-interact-with-a-report-in-reading-...
but it's seems to be not really working.
I can visualize line chart for any particular product, but can't do it interactive.
Hi - Power BI works best with data that's in a tabular format. If you use the Power BI Desktop to unpivot the data around so that you have three columns: Product, Date, Sales, you'll have more luck. The interactivity should just happen automatically if you have two visuals based on that data.
There's more info on that function here:
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.