I have this SharePoint list which store Total Number of work orders and Total Number of Completed work orders for each month & year & MediumID, as follow:-
now i want to show the above inside ColumnCart inside a gallery. so this what i did so far:-
I added a gallery with this Items property:-
'KPI Dashboard Per Medium'
inside the gallery i added a Columnchart as follow with this Items property:-
{Date:ThisItem.Month.Value&ThisItem.Year,Total:ThisItem.TotalNumberWorkOrders,Completed:ThisItem.TotalNumberCompletedWorkOrders}
inside the Columnchart i added these advance settings:-
and i set the number of series to be 2. now i will get these column charts as follow:-
but how i can make these changes:-
- the Legend is currently showing Series1. so how can show the label of the charts instead (Total & Completed instead)? currently the legend has this settings:-
so how i can show this legend instead:-
- can i show Total and Completed titles under each column? so Total under the solid green column and Completed under the light green column?
Thanks






