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.

       

       

      • esteban_viz's avatar
        esteban_viz
        New Member
        2 years ago

        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