Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Number value is adding to Chart as 'Count of'

I have a chart that looks like the below. 


When I convert this to a line and column, it automatically convert the 'PM Count' column to be 'Count of PM Count' and therefore displays the values incorrectly. 






Below you can see that field is clearly a numeric value and is formatted as such. 



Community Support
Community Support

Hi  @CharlotteOW ,

You can try to create a measure and put it in:

Measure =
MAX('Table'[PM Count])

If I have misunderstood your meaning, please provide your desired output.


Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hey - this still doesn't work as it just shows me the max value across every month rather than the individual count per month. 


Here is my table and the last column is what I want to have shown in the chart. This is just a field from an table. 





Super User
Super User

@CharlotteOW , Other than table visual, no other visual support Not Summarized column in values. Values have to be aggregated or use on axis

Thank you for the response, what would be the best way around this? 


Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors