The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
name | size | country | size2 | size3 | Month |
A-161123.5 | 1 | CAN | 1.2 | 1.8 | 201809 |
beta | 0.5 | US | 0.6 | 0.9 | 201809 |
A-161123.5 | 1 | CAN | 1.2 | 1.8 | 201810 |
beta | 0.5 | US | 0.6 | 0.9 | 201810 |
hi, @ahuhn
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".
Best Regards,
Lin