Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
CharlotteOW
Frequent Visitor

Number value is adding to Chart as 'Count of'

I have a chart that looks like the below. 

CharlotteOW_0-1658830425246.png

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. 

CharlotteOW_1-1658830540795.png

 

 

CharlotteOW_2-1658830554766.png

 

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

CharlotteOW_3-1658830593628.png

 

4 REPLIES 4
v-yangliu-msft
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. 

 

CharlotteOW_0-1659110440237.png

 

 

amitchandak
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

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors