Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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