Scatter Plot X-Axis Date Issue

Great question. This is a classic Scatter Chart + Date granularity limitation in Power BI.
Let me explain why this happens and then give you solid, practical solutions.

Why the problem occurs?

1. A Scatter chart X-axis is always continuous
2. When you put Date on X-axis:
   • Power BI plots each individual date (which is good )
   • But formatting it as MMM-YYYY collapses visual meaning, because multiple dates now look like the same label

So you want:

• Granularity = Daily (4/1, 4/5, etc.)
• Label appearance = Monthly (Apr-2025)

This requires separating sorting logic from display logic.

----------------------

SOLUTION: Use a numeric Month Axis + Tooltip for actual dates

Step 1: Create supporting columns

In your Date table (or fact table if needed):

---DAX Code---

MonthStart = DATE(YEAR('Date'[Date]), MONTH('Date'[Date]), 1)

MonthIndex = YEAR('Date'[Date]) * 100 + MONTH('Date'[Date])

MonthYearLabel = FORMAT('Date'[Date], "MMM-yyyy")

---DAX Code---

Step 2: Configure the Scatter Chart

Scatter Property & its Value

• X-Axis ==> MonthIndex
• Details ==> Date (very important)
• Y-Axis ==> Your measure
• Tooltips ==> Date, measures
• X-Axis Type ==> Continuous

Step 3: Fix the X-axis label

• Go to X-axis formatting
• Turn Concatenate labels = OFF
• Set Custom label using MonthYearLabel (if using tooltips or titles)

Result:

• Bubbles plotted for each date
• Dates cluster within the same month
• X-axis visually represents Apr-2025, May-2025, etc.

What this gives you visually

For Apr-2025:

• Separate bubbles for:
  • 4/1/2025
  • 4/5/2025
  • 4/12/2025
• All aligned under Apr-2025
• No loss of detail

=================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Jaywant Thorat | MCT | Data Analytics Coach
LinkedIn: https://www.linkedin.com/in/jaywantthorat/

Join WhatsApp Community = https://shorturl.at/5ViW9

#MissionPowerBIBharat
LIVE with Jaywant Thorat from 15 Dec 2025
8 Days | 8 Sessions | 1 hr daily | 100% Free