unable to use don't summarize option for a line graph

[Anonymous]

I'm trying to create a line graph based on % column but it aggregates the value and I don;t see an option to use don't summarize in aline graph. 

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Line chart visualization is used to display summary data. You can image the line graph. The Axis property is the column group of the matrix, and the Legend property is the row group of the matrix. If there are multiple records at the same intersection of a column and row group, these values need to be aggregated. Therefore, there are many aggregate functions that can be used to aggregate data instead of "not aggregate".

The "Default Summarize: No Summarize" option applies to the field itself. Once the file is placed in the vision, it will depend on the vision design to use it. In chart vision, "not summarized" is not available, but in table vision, it can be supported.

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.

[pranit828]

Hi @Anonymous 

For each data point on X-Axis graph line graph has to show one value which need to be aggregated at some level causing you not to see the option. The graph can't have same data points more than once for sanity.

[Anonymous]

Is there any other way to show the values in line graph like  using dax?

[pranit828]

@Anonymous 

Nopes, Don't summarize option uses is limited in this case.