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?

 

 

10 REPLIES 10
Pierre_CH
New Member

Using the online PowerBI version, you may add a text box on top of the "count of .... " text.

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.

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?

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.

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
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!