Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
You may take advantage of the Legend field.
https://community.powerbi.com/t5/Desktop/graph-trouble-summing/m-p/564094#M266151
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |