Forum Discussion
How to stop POWER BI from summarizing
Hi,
I have question regarding "Don't Summarize" function in Power BI. as showing below, i have set my table value " CBA Average" as "Don't summarize". however, when create line chart, it will count value but not displaying true value by date.
Can I get help with it? Thank you!
Hi Jac1117 ,
Line charts do not display text values.
So by default, it won't display "Don't summarize" in the line chart. If your values are numeric type, SUM is actually equivalent to don't summarize, if you have categories in the table that you want to display group by categories, you can add categories to Legend.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
here are two screeshots from Power BI:
- amitchandak
Super User
Jac1117 , In line visual don't summarize only supported on x-axis not on y-axis. Y-axis will aggregate
Thank you so much for your reply amitchandak May I ask how i can stop summarizing y-axis but just simply disply the value by date? thank you again!
Hi Jac1117 ,
Line charts do not display text values.
So by default, it won't display "Don't summarize" in the line chart. If your values are numeric type, SUM is actually equivalent to don't summarize, if you have categories in the table that you want to display group by categories, you can add categories to Legend.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have the same problem and i've checked that the data type is a number and it's set to don't summarize but in the visual it still does!
Can anyone help with an answer?Thanks!
