cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
setis Member
Member

Visualization with repeated days

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?days.PNG

2 REPLIES 2
Community Support Team
Community Support Team

Re: Visualization with repeated days

@setis,

 

You may take advantage of the Legend field.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
setis Member
Member

Re: Visualization with repeated days

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: 

diffDate.PNG

 

As per your suggestion, I created a calculated column: 

CC.PNG

 

 

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.