Dont summerise not working

[Yodash]

I have the most simple input in csv file. ColA is time , colB is vals
time=1, 2 , 3, 4, 5.....up to 100  
Vals = 3, 4, 1....rundom vals
I try to make the most simple line chart where Axis_x is time. I define both cols as dont summerise..but still..i dont get the line i expect.. power bi insists to sum or count the data
So simple but not working..how can i make it work?

[v-fenling-msft · Accepted solution]

Hi, @Yodash 

I am glad to help you.

Some visuals such as Line Chart visual, Stacked column chart visual, etc. that have a Y-axis are required to use aggregated values by default. Even though you have set the field don't summarize.

If you want him to display according to the original value, then you have to make sure that the value of your Time field is unique, so that even if you use summarize, the calculation is actually still the original value:

But if your Time field is not unique, he will do a sum calculation for the same Time value:

At this point adding an ID field as a unique value for each row and dragging the ID to Legend will show each data point, but will not show the trend of the data directly:

I've attached the pbix file for this little example below, I hope it helps.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Yodash]

Thanks, that really helped!

[tomershm]

Hi @v-fenling-msft ,
Is a similar solution possible for a stacked bar chart featuring string events over time?
for example, "start" / "end" in column "state" along time, and with the purpose of the visualization showing the bars along the "time" X axis. treating each time row as a distinct point while having the bar be continuous. something similar to this:

[uzuntasgokberk]

Hello @Yodash,
For line chart, you can keep Values and set a summarization for x- and y-axis. Therefore you couldn't show don't summarize value. İt needs an aggreation on that.
Also there is an old ticket about that you can check it:https://community.fabric.microsoft.com/t5/Desktop/Option-to-choose-quot-Don-t-Summarize-quot-Missing...

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

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