Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to plot a line chart without aggregating

Good Day. I am trying to make a project that models COVID-19.   I have the following data:   Where column 1 is text - date is in the date format, -  columns from total_cases  to total_re...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    In your screen shot, it shows "Count of total cases by Year", it means the count of date which has case in the year 2020, 2021, 2022. So in your screen shot line chart there's only three value.

    Just keep the Summarization of the total cases column Sum.

    The Values should also be Sum.

    The Axis should be date, not year.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

     

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

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Set your x-axis to be the date instead of the Date Hierarchy for starters. You do that in the field well of the Visualizations pane for the Axis. You might also want to use a Categorical axis instead of Continuous.