Forum Discussion
Data set built on pivot table
Hi BI gurus. I would like to ask. Is it possible to create visualization on data from pivot table? On youtube channel video : Prepare your data for Power BI https://www.youtube.com/watch?v=l2wy4Xg...
mstefancik,
you can't use Pivot Tables if you use excel file as a source. The uploaded Excel file has to meet following conditions described in this artice: https://support.powerbi.com/knowledgebase/articles/424871-excel-data-in-power-bi
Generally speaking you have to prepare data in flat table. You can also create model in PowerPivot (more details in mentioned article)
Thx I understand, I just wanted to clear it out. On the other hand, pivot table should be inmplemented as one of the visualizations charts.
