I have a DashBoard with a slicer to swap between 2018 and 2019
I have a Pie Chart that shows TOP 5 and it works when I doen't use the slicer....
What am I doing wrong.
Any help much appreceated
I have a DashBoard with a slicer to swap between 2018 and 2019
I have a Pie Chart that shows TOP 5 and it works when I doen't use the slicer....
What am I doing wrong.
Any help much appreceated
It appears to me as if the slicer is working. The pie chart is being filtered to show items with the top 5 values.
In the case where both 2018 and 2019 are chosen there are only five items that have the top 5 values.
In the case where 2018 is chosen six items have a value of 11.11%, which is the 2nd highest value.
In the case where 2019 is chosen eight items have a value of 3.70% which is the 5th highest value.
I don't know what you expect the chart to display, so I can't be more helpful.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank You JeteMc
It is just some DommyData I have put in to test it.
I can se the problem, When there are multiple items with the same value, the Slicer shows all the values.
I should think that when the real data is used it will work as there will be no items with the same value.
Fingers crossed :-)
Can I ask you if you know a way to Prevent the right Clik menu on the Slicers?
Mayby VBA?
You're Welcome.
As to preventing the right click menu on a slicer, sorry I don't know VBA so I can not help.
My suggestion would be to close this thread by marking it as 'Solved' using the thread tools menu above your first post and then open a new thread in the VBA forum addressing that question.
I hope that you have a blessed day.
Thanks JeteMc
I will mark it as solved.
And a very blessed day to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks