Scatter Plot X-Axis Date Issue

Rehansaeed2024 , Format you date as "MMM-YYYY" and try. It should be date just formatted,

Or add the date to the details. 

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

Hi  Rehansaeed2024 i hope you are doing well!

1. Create a proper Date table (if not already):

    

    

   DateTable = ADDCOLUMNS ( CALENDAR (DATE(2024,1,1), DATE(2026,12,31)), "MonthYear", FORMAT ( [Date], "MMM-YYYY" ) )

    

   1. Create a numeric Month key (important for sorting & axis control):

       

       

      MonthYearSort = YEAR([Date]) * 100 + MONTH([Date])

       

      1. In the Scatter chart:

         • X-Axis → Use the actual Date column (not MonthYear)

         • X-Axis Type → Continuous

         • Y-Axis → Your metric

         • Details → Date (or Transaction ID) → this ensures one bubble per date

         • Legend / Size → As needed

           1. Format the X-Axis to show Month-Year only

              • Go to Format → X-Axis

              • Set Display units = None

              • Set Concatenate labels = Off

              • Set Minimum category width (adjust until Month labels look clean)

                1. (Optional – clearer month separation)
                   Create a Month Start column:

                    

                    

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

                   Use MonthStart on the X-Axis (continuous) and keep Date in Details.

Here is a sample data. I would like to show 'mmm - yyyy' on X-Axis and would like to show all the Product ID bubbles during that month.