why don't I get the no resume button on my line graph in powerbi?

[alejandroRodri]

I have the following dataframe which simply records data from a questionnaire conducted on 2 different dates (November 2023 and February 2024). The columns are:

Date
Category ( each of the items that are scored in the questionnaire)
Name of the person
Value-November (Value 1-10 you have given to category X in the November questionnaire)
Value-Feb (Value 1-10 given to category X in the questionnaire in February)

With this data I want to make a line graph showing one line for the November data and another line for the February data. On the X axis I want to show the categories that have been evaluated and on the Y axis the respective value that has been given to the item, both in November and February, in order to see the evolution along all the categories and to be able to compare the November data with the February data at a visual level.

The problem is that when representing the points on the Y axis, I can't select the option Do not summarize to show the data as I have them in the df, but I have to do an aggregate operation, which means that the data are not shown as I want. How can I solve this?

[Anonymous · Accepted solution]

Hi,@alejandroRodri 
I am glad to help you.

According to your description, you want to compare user scores for the same question in two surveys, but when using a line chart, you find that the y-axis can only hold values of the aggregated type, and not the values from the original data alone (i.e., the y-axis can only show the total of everyone's scores for the same question).

Unfortunately, the "Do not aggregate" option does not normally apply to fields that Power BI identifies as needing to be aggregated, such as numeric fields in a visual object that essentially aggregates data, such as a line chart. This behavior is by design, as Power BI is intended to provide aggregated insights into data trends, not individual data point mappings in some visual objects.

So if you need to use line charts, then the Y-axis must hold aggregated fields!

You can bypass this limitation based on your specific needs:

If you want to compare the scores of each respondent for the same question in two surveys, you can create a slicer using the scorers to show the scores of individual respondents
like this：

Or you can choose other types of visual (without summarizing the data) besides line charts, such as Scatter charts

Scatter charts in Power BI allow placing individual data points without summarizing them.

Here is the official documentation about power BI Scatter charts:
Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn

Please modify the filter conditions of the icon according to your needs.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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