Forum Discussion

Yodash's avatar
Yodash
Regular Visitor
1 year ago
Solved

Dont summerise not working

I have the most simple input in csv file. ColA is time , colB is vals time=1, 2 , 3, 4, 5.....up to 100   Vals = 3, 4, 1....rundom vals I try to make the most simple line chart where Axis_x is tim...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Yodash 

    I am glad to help you.

     

    Some visuals such as Line Chart visual, Stacked column chart visual, etc. that have a Y-axis are required to use aggregated values by default. Even though you have set the field don't summarize.


    If you want him to display according to the original value, then you have to make sure that the value of your Time field is unique, so that even if you use summarize, the calculation is actually still the original value:

     


    But if your Time field is not unique, he will do a sum calculation for the same Time value:

     


    At this point adding an ID field as a unique value for each row and dragging the ID to Legend will show each data point, but will not show the trend of the data directly:

     

    I've attached the pbix file for this little example below, I hope it helps.

     

     

     

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Fen Ling,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.