I am currently displaying a pivot chart with data of Hours per week of an employee. It has the Week on the horizontal Axis and Hours on the vertical axis Axis with users as legend.
I also have a slicer that would let me to select different users.
When I change the users, the data label of the first user doesn't seem to appear on the chart, I've tried to change the pivot chart settings but none of the change helped me with this.
I have attached an image of how the chart looks like
Can someone please point me towards the right direction to proceed
Edit- I would not be able to attach the excel here as the slicer list / chart data comes from the database query result according to the slicer option selected and I use Microsoft query for that.
Thanks.
Bookmarks