Evolution of a mark during date

[Océane]

Hi everyone!

I have a object with a mark that elvolve during time. For example in 2016 it's 2, in 2017 it's 5, in 2018 it's 4...

I would like to display this data using a column or a line chart :

                  |

                  |           |

                  |           |

       |          |           |

       |          |           |

   2016   2017    2018          for example

I have a table with my date column and an other with my mark. The two tables are linked.

I specify that the data I'll use is for one object and one onely as I filter them before to use them on this visual.

The problem is, when I trie to use le column chart (or any other chart), I can't choose "don't summarize", I have to count or sum or average... my field, which is not what I want.

Does anyone can help me?

Thanks! 🙂 

[HotChilli]

I think you can use SUM and you'll get the chart you want.  Graphs and charts in powerbi are meant to show aggregations, so if you have one value per category, SUM works the same.

From memory I believe that once the field is dragged on to the VALUES section it doesn't show 'SUM' if there's only one value, because people get upset!

[Océane · Accepted solution]

Your post gave me an idea. I tested some things using the SUM aggregation and some other fields I have (and that I didn't think useful) and It worked!

Thank you very much! 🙂

[Greg_Deckler]

Need to see example source data for this. Seems like you could use any aggregation if you only have one value for each year. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Océane]

With an aggregation, I have the same data for all dates even if the mark is different.

Unfortunatly, I'm not free to share data sample with you.

All I can say is that I have tow column usefull here :

Date    Mark

2016       2

2017       5

2018       4