Forum Discussion
Kudo CommanderPie 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
Resolver IHey 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
Kudo CommanderThank you so much for taking time to respond for the solution. I will try tomorrow and let you know the outcome.
Regards,
Amit Devkatte