Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |