Forum Discussion

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

Make a column not sum/count

I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations.  I am still fairly new to this though and cannot figure this out.    I imported a ...
Need Help
v-esdev's avatar
v-esdev
Microsoft Employee
9 years ago

Hi All,

 

I am also facing same issue. does anyone find solution for this.

 

Please help me on this.

 

Thanks,

Eswar

kmpiscopo's avatar
kmpiscopo
New Member
9 years ago

 

Check the data format within your Excel document.  I've found that if the values in my tables in Excel are not "Number" (e.g. if they are listed as "Accounting" or "General" or "Custom"), then Power BI doesn't recognize the data as values, and your only options for pie or bar charts is either "Count of (data field)" or "Sum of (data field)", etc.

Hope this helps!