Solved: Allow Duplicate Values on X-Axis

Nankaina · ‎11-28-2023

I feel like this should be a simple question but I have had no luck finding a solution.

We use run charts pretty regularly as a good way of tracking trends and changes over time, and I've been asked to replicate those in PowerBI. Since we're looking for trends event-by-event, rather than day-by-day, distance between dates isn't particularly relevant; but multiple events on the same date absolutely are.

Currently, what I've got looks something like this. The X-axis is showing dates, the Y-axis showing Duration for each point.

PowerBI is automatically summarizing based on date, so each point above represents a date. We want each point to represent an event. With the power of editing on my side, here's a mock-up of what I want it to look like:

Two things of note:

1. events are spaced evenly, rather than proportional to the time interval between them

2. two events with the same date are shown as separate points, rather than averaged as a single point (here the y-values are also identical, but they are occasionally different)

If necessary, I can get info that can help distinguish points with the same date (an index column, time values, names, etc). I've found a lot of half-measures that solve one problem but create another (like treating the dates as text, which then takes them out of chronological order), but nothing that completely works. The data is updated regularly, so solutions must withstand the introduction of new points.