Forum Discussion

siddrow's avatar
siddrow
Helper III
3 years ago

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...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Your X axis minimum can be set by a measure.

 

Before:

 

After:

 

siddrow's avatar
siddrow
Helper III
3 years ago

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"))