Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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. 

 

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

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
Community Champion
Community Champion

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.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

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

@Anonymous 

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





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors