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...
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.
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.