Visualization with repeated days

[setis]

Hi all, 

I have a list of payments and many of those are on repeated days. I would like to visualize the nr of days based on every row but I don't want to sum the values for the repeated dates.

I don't know if it's possible but I need a timeline with repeated dates and a chart with the number of days. Not sum, not average. 

The one attached is with SUM of nr. of days. for rows with the same date. Is this possible?

[v-chuncz-msft]

@setis,

You may take advantage of the Legend field.

https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151

[setis]

Dear Sam, 

Thank you for your answer. It's not really doing it for me. 

What I'm trying to visualize is the days passed from a Due date for an invoice and the posting date for the same invoice. 

Due to the nature of this table, there are many lines with the same date and I don't want to sum the amount of days. 

The composition of the current chart is this: 

As per your suggestion, I created a calculated column: 

and I tried to create a line chart and setting this column in the legend field as per the your reference post suggested, but there is someting wrong.