Forum Discussion

Rehansaeed2024's avatar
Rehansaeed2024
Frequent Visitor
8 months ago
Solved

Scatter Plot X-Axis Date Issue

I have a requirement to Show the data on a Scatter plot. X-Axis should show 'MMM-YYYY' format but at the same time I also would like to see the bubbles for all the dates making up for that months so ...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    7 months ago

    Hi Rehansaeed2024,

     

    Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to rehansaeed2468, Nabha-Ahmed, Jaywant-Thorat, amitchandak, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

     

    outcome:

     

    I am also including .pbix file for your better understanding, please have a look into it.

     

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum

Nabha-Ahmed's avatar
Nabha-Ahmed
Super User
8 months ago

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.

 

  • rehansaeed2468's avatar
    rehansaeed2468
    Helper I
    8 months ago

    Can u pls attach a sample PBIX File if possible