Forum Discussion
Scatter Graph HELP!!!!
Hi Everyone,
Trying to create a scattered graph in Power bi and six of my Catergory labels have markers but the other two dont. I dont understand what is going on.
No worries! Let me simplify it for you:
Here are some things to check if some category labels in your scatter plot have markers and others don't:
1. **Check your data**: Make sure the two categories without markers have data in your dataset. If the data is missing, Power BI won’t show the markers.
2. **Marker size**: Sometimes, the marker size is too small, making them invisible. To fix this:
- Select your scatter chart.
- Go to the **Format pane** (on the right).
- Find **Markers** and increase the size.3. **Filters**: Make sure there are no filters on your report or chart that could hide those two categories.
4. **Data aggregation**: Check how Power BI is calculating the values. If it’s summarizing them in a way that leaves zero or missing values, change the way it’s aggregated (like using **Sum**, **Average**, etc.).
5. **Overlapping markers**: Sometimes, two categories might have the same data points, so their markers overlap. You can increase the transparency of the markers to see if they are stacked on top of each other.
Try these steps and let me know if it works!
2 Replies
No worries! Let me simplify it for you:
Here are some things to check if some category labels in your scatter plot have markers and others don't:
1. **Check your data**: Make sure the two categories without markers have data in your dataset. If the data is missing, Power BI won’t show the markers.
2. **Marker size**: Sometimes, the marker size is too small, making them invisible. To fix this:
- Select your scatter chart.
- Go to the **Format pane** (on the right).
- Find **Markers** and increase the size.3. **Filters**: Make sure there are no filters on your report or chart that could hide those two categories.
4. **Data aggregation**: Check how Power BI is calculating the values. If it’s summarizing them in a way that leaves zero or missing values, change the way it’s aggregated (like using **Sum**, **Average**, etc.).
5. **Overlapping markers**: Sometimes, two categories might have the same data points, so their markers overlap. You can increase the transparency of the markers to see if they are stacked on top of each other.
Try these steps and let me know if it works!
Check if the two missing categories have values that overlap or fall outside the current axis range. Also, ensure all categories have distinct values for X and Y axes. You might need to adjust the axis scale or check for filters affecting those categories.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
