Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to 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.
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.
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.
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 |
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.
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 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |