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

     

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      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's avatar
        siddrow
        Helper III
        3 years ago

        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.