Need your help!
I have a scatter chart and I have eneterd the start and end values for X-axis as 1 and 60 and for one dataset it looks good since values are below 60 but for another it goes around 200 and the bubble goes out of the screen. I have not kept these values balnk intesionally since I need to show values at 1 and not for 0.
Is there any way that the start and end values could be made dynamic? I mean it would adjust automatically at the maximum counts of the values with each dataset respectivley?
>>I mean it would adjust automatically at the maximum counts of the values with each dataset respectivley?
It is analysed by datasource value range by visual itself.
For you scenario, you can try to create a calculated column with if statement to replace values which too big or too small values as static value.
If you still confused on this, share some sample data with expected result to help us clear your requirement.