cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
getupgal
Regular Visitor

Need to remove "count of"

I'm trying to create a very simple graph from data pulled in from Excel (in Power BI app). I have created the graph before, but now for whatever reason I am getting the following "Count of" or "Count (distinct)" as my only options which is not what I want to depict in the graph.

 

Usually I can select from "Sum", "Average" etc, but not for this data.

 

Any suggestions?

 

 

9 REPLIES 9
KHorseman
Community Champion
Community Champion

Check the column's data type. It is clearly not a numeric type.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I have it formatted as Accounting, which is what I have used previously with no issue.

KHorseman
Community Champion
Community Champion

No you don't. "Accounting" is not a data type in Power BI. The Excel file doesn't matter. Check the data type in Power BI.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




How would I do that?

KHorseman
Community Champion
Community Champion

Check the Modeling tab in the ribbon and look at the data type there. Or check the data type of the column in the query editor.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




I don't have a ribbon...I'm working in the online version.

KHorseman
Community Champion
Community Champion

Use the desktop app.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Unfortunately I'm a beginner and I can't figure out what I'm doing.

@getupgal

 

It's not supported to change the aggregation type in Power BI Service (the online version Power BI that you are accessing via Power BI Mobile. You have to edit aggregation type in Power BI Desktop, then publish it onto Power BI Service.

 

133.PNG

 

Regards,

 

 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors