Forum Discussion
Power BI map bubbles skewed
I am trying to replicate the first visual , but as you can see my open/closed data is flipped and also the percentage rate has increased 10x. What could be causing this ? These fields work fine in other visuals.
Hi AmrithaRam -The fields in your pie chart might have been incorrectly mapped or referenced, causing the labels for open and closed jobs to be swapped.Double-check the fields in your Legend and Values sections of the map visual. Make sure that "Open" and "Closed" statuses are correctly assigned and that the corresponding measures for each are accurate.
regarding percentage: Check if the Conv Ratio calculation in this specific visual is different from how it’s calculated in other visuals. If you're using SUM or COUNT incorrectly, the Conv Ratio might be over-calculated. You may want to use AVERAGE or create a specific measure to calculate the ratio per state. Check the formatting of the Conv Ratio measure in the Format pane. Ensure that it is set to Percentage and displayed with the correct number of decimal places.
regarding size, check on slicers, page-level, or report-level filters are applied correctly and not unintentionally affecting the Open/Closed fields.
Hope the above tips helps you to fix the issue.
3 Replies
- amitchandak
Super User
AmrithaRam , Yiu can choose the top colors to change that. Also if there % column it should be a ratio A/B, not A/B*100 . Percent measure/column display value *100
- rajendraongole1
Hi AmrithaRam -The fields in your pie chart might have been incorrectly mapped or referenced, causing the labels for open and closed jobs to be swapped.Double-check the fields in your Legend and Values sections of the map visual. Make sure that "Open" and "Closed" statuses are correctly assigned and that the corresponding measures for each are accurate.
regarding percentage: Check if the Conv Ratio calculation in this specific visual is different from how it’s calculated in other visuals. If you're using SUM or COUNT incorrectly, the Conv Ratio might be over-calculated. You may want to use AVERAGE or create a specific measure to calculate the ratio per state. Check the formatting of the Conv Ratio measure in the Format pane. Ensure that it is set to Percentage and displayed with the correct number of decimal places.
regarding size, check on slicers, page-level, or report-level filters are applied correctly and not unintentionally affecting the Open/Closed fields.
Hope the above tips helps you to fix the issue.
Hi AmrithaRam ,
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered? If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!
