Scatter chart cutting off plot data

[siddrow]

Hi

I am using a scatter chart and noticed that the dots are half cut off.

I cannot use minimum and maximum range in the X-axis as my chart is a rolling 25 year period as I have a filter added to my chart that only brings in data that is within a 25 year period which is calculated from current year +25 years. e.g. in this financial year, the chart will only show data between FY23-FY48, next year it'll only show FY24-FY49 and so on. I don't want to have to go in every financial year and update the minimum and maximum range. Is there a workaround for this?

thanks

[aishs_15]

what about the top bubble which gets cut off? Were you able to handle that as well? In my case both X and Y axis are measures so I wont be able to add additional data.

[lbendlin]

Your X axis minimum can be set by a measure.

Before:

After:

[siddrow]

Hi

Thanks for your reply. Is it possible to utilise my current measure that I am currently using as a filter on the visual (brings through the next 25 years of data)? Or can I create another measure off that measure? The only issue with me bringing another year at the front and back of the data (so the dots aren't cut off) is that to the end users, it will look like there's no data in those years, although the plan is to only show a 25 year plan. I'm guessing there's probably no workaround for this. It's either have them half cut off and show 25 years of data OR add a measure to show an additional year at the front and end, however this will technically cover "27 years".

current measure:

= IF(NOT(ISBLANK([FY Final 3])),if([FY Final 3]-[Current Financial Year]<=25,"Yes","No"))

[lbendlin]

If you noticed my measure added (well, subtracted) half a year.  There is no risk of additional data points being shown.

Please provide sanitized sample data that fully covers your issue.

[siddrow]

thanks, I ended up working out what I needed to do. Created some date/month/year custom columns which then allowed me to create a FY year custom columns and then I created two measures based off the FY (current FY minus 1 year and current FY plus 26 years), which I used for my min and max and then created a filter to only show the 25 year period data only. It will automatically change every new FY, so I won't need to go in and change the min & max.

[esteban_viz]

Hello,

I have similar issue, I'm going to try your solution, if you can give more detail it would be great.

My chart is showing on X the percentage missed to reach a goal and Y the backers that participated with donations in a campaign. The plot data at the extremes are hidden I'd like them to show complete:

Here my graph, highlighting the dot cut off:

If need more details even the power bi desktop project , I can share.

Thanks in advance