cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Can we create pivot tables and pivot charts akin to Excel in Power BI Desktop?

I'm new to Power BI Desktop and can't seem to make pivot tables and charts as quickly and easily or correctly as compared Excel.  Is there an option to this to make it easier to create?

 

For example: In Excel, I used line item data and summarized that data on a separate sheet.  I then created pivot tables and charts from the summarized data.  This gave me accurate representation in charts of what I calculated. 

 

When doing this in Power BI Desktop: I imported both line item and summarized data sheets into Power BI desktop.  However, the charts created from the Power BI Desktop doesn't seem to calculate the pivot table values like Excel.  Is there a trick to doing this in Power BI Desktop? Subsequently, the charts did not reflect the data I was hoping to see.

 

Please let me know if there is a trick I'm missing here.

thanks,

 

james

 

11 REPLIES 11
New Member

Hi,

 

Why there is no columns table like pivot table in power bi.

 

Regards,

Dyson Isaac

You can create tables and matrix by using different visualization chart

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors