Making pie charts based on a aggregated datatable

Question

Hi,&nbsp;I want to make pie charts based on this table in PowerBI (aggregated data):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This must be the result (made in Excel, but I want to do it in PowerBI):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How can I make these pie charts in PowerBI? It looks PowerBI is only counting records, but does not show the values in the cells.&nbsp;&nbsp;Kind regards,Stefaan&nbsp;&nbsp;

dramus · Accepted Answer

I think your data must be set to a text datatype.&nbsp;&nbsp;Using this data:&nbsp;&nbsp;I was able to produce this bar chart:&nbsp;

Forum Discussion

Making pie charts based on a aggregated datatable

2 Replies

Related content

Datatable options

DAX DATATABLE

Data Aggregation issue

Aggregate

LBL or Aggregation Upstream