Vizual interaction, connecting few charts.

[Volodymyr]

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.

Thanks for help

[WillT]

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:

https://support.office.com/en-us/article/Unpivot-columns-Power-Query-0f7bad4b-9ea1-49c1-9d95-f588221...