Excel pivot tables

[dkehoe32]

I need to make this colored table in BI but I have no idea how to do that as all the quantities are calculated in the pivot tables.  Im very new to BI and have no idea where to start

[v-danhe-msft]

Hi @dkehoe32,

Based on my research, you could use the “Import” function to Import Excel workbooks into Power BI Desktop, this function could easily import Excel workbooks that contain Power Query queries, Power Pivot models, and Power View worksheets into Power BI Desktop.

You could refer to this link: https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

Regards,

Daniel He

[dkehoe32]

Hi, that doesnt work as it says theres no models to import