Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to add a border of a different colour (based on another dimension) to shape in a scatter plot. This cannot be curerntly done in power bi, so I thought of a work around.
I will make one scatter plot, and set its size of 1:4.
I made another scatter plot visual, whose size is 2x value in the above plot.
I planned to overlap them, so that the larger shapes would overlap the smaller shapes, thus creating a halo around the smaller shape. Then I can colour the halo by category.
Unfortunately, this does not work, and the shape sizes are identical when I overlap them.
Any suggestions on a possible work around?
here is my data:
here is what each look like when I plot
1- labels on, default size
2- labels with size
3- labels with size2
here is what it looks like when i overlap 1 on top of 2 - which is good
here is what it looks like when i overlap 2 on top of 3 - which is not good
what i want is to be able to have the plot 2 on top of 3, and have the halo of 3 surrounding 2, like this (made in ppt)
Any suggestions?
Solved! Go to Solution.
Hi @ahuhn
You may use 'Unpivot Columns' in Query Editor first. Then you may create the visual as requested. Here is the sample file for your reference.
Regards,
Cherie
Hi @ahuhn
You may use 'Unpivot Columns' in Query Editor first. Then you may create the visual as requested. Here is the sample file for your reference.
Regards,
Cherie
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |