I have a scatter plot visual
I have 3 layers of data, so I can show concentric circles, each representing a different category.
- the bottom layer represents country - US, CAN, Mex
- the second layer represents type of account - A, B, C
- the top layer is to get the information about the point, project name
I set it up on all the data so that it works fine, but when I select a slicer for a different month, the visual changes.Any suggestions as to why this occurs.
Here is how I want it:
Here is what happens when I select all slicer options. Bubbles increase in size a little
Here is what happens when I select a different month - I do not want this, but want to know why it occurred. All of the columns and logic are the same for the month that I do want. Bubbles increase in size a lot and lose the border bubble
Here is a snippet of the relevant data
This is a normal phenomenon when you filter the data by slicer, the visual will respond to the change.
and you could custom some of them in "Format".