Forum Discussion
Scatter chart cutting off plot data
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
6 Replies
Your X axis minimum can be set by a measure.
Before:
After:
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"))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.
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.
