Pivot chart “showing details”

%3CLINGO-SUB%20id%3D%22lingo-sub-190865%22%20slang%3D%22en-US%22%3EPivot%20chart%20%E2%80%9Cshowing%20details%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190865%22%20slang%3D%22en-US%22%3Ehello%2C%20i%20have%20excel%202016%20and%20need%20help%20with%20setting.%20Before%20I%20got%20the%20office%20updates%2C%20it%20was%20possible%20to%20select%20multiple%20elements%20in%20a%20Data%20cut%20(or%20slicer)%20and%20displaying%20the%20details%20(show%20details)%20in%20the%20diagram%20(pivot%20chart)%20.%20Now%20it%20comes%20an%20error%20message%2C%20I%20should%20only%20select%20one%20element%20in%20the%20data%20cut%20to%20display%20the%20details.%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20they%20change%20it%20%3F%20Or%20can%20I%20change%20the%20settings%20%3F%20I%20couldn%E2%80%99t%20find%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20in%20you%20in%20advance.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-190865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190867%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20chart%20%E2%80%9Cshowing%20details%E2%80%9D%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190867%22%20slang%3D%22en-US%22%3E*using%20power%20pivot%20with%20a%20data%20model%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
hello, i have excel 2016 and need help with setting. Before I got the office updates, it was possible to select multiple elements in a Data cut (or slicer) and displaying the details (show details) in the diagram (pivot chart) . Now it comes an error message, I should only select one element in the data cut to display the details.

Do they change it ? Or can I change the settings ? I couldn’t find it.

Thank in you in advance.
1 Reply
Highlighted
*using power pivot with a data model