Help to clean data

Hi VDS9 ,
According to your description, you need to process the data and show the trend after the data changes.
First, you need to classify or aggregate the data so that you can visualize the statistics of the data at various levels of granularity (type, time, etc.), which can be done technically as 0, 1, or -1. You can do this through grouping in power query, or aggregation functions in dax.
After you clean up the data and create the dax function, you can show the trend through a visual legend such as a scatterplot or line graph, and determine whether the negative score has increased or decreased throughout the time period from the density of the scatterplot.
You can refer to this document to learn how to create a scatterplot:
Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

Best regards,

Albert He

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