Forum Discussion

CharlotteOW's avatar
CharlotteOW
Frequent Visitor
4 years ago

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. 

 

bar chart
chart
count of
foramt
line and column
Number
values

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

    • CharlotteOW's avatar
      CharlotteOW
      Frequent Visitor
      4 years ago

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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • CharlotteOW's avatar
      CharlotteOW
      Frequent Visitor
      4 years ago

      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.