Pie chart issue in pyspark notebook

Hey Amit,

It’s actually the Series group setting causing the double charts.

You have Qty selected there, so it’s trying to split the view and create a separate pie for every quantity.

Just clear the Series group field (leave it empty) and you’ll get a single chart.
For the mapping confusion:
- Xaxis = Legend (CityId)
- Yaxis = Values (Qty)

If you find the notebook charts limiting, you can create a Visual Query from your Lakehouse explorer. It gives you a full drag-and-drop interface to build your charts without coding!

(Just remember to save your DataFrame as a table first, otherwise the Visual Query editor won’t pick it up).

Let me know if that works. If it does, a Kudo and marking as Solved would be appreciated!

QuentinGa