bsharpgrooves
New Member
- Joined
- Mar 19, 2020
- Messages
- 1
- Office Version
- 2016
Hello
I've created a power pivot and a power chart off of it as seen below. I have a source table with various columns, etc. I would like to be able to see the data set when I double click (or click or mouse up, etc) on the series. When I double click I get I get "we can't drill down here."
I would like to see the details in a separate sheet called "DrillDown" (just like in this post here: https://www.mrexcel.com/board/threads/pivot-table-drilldown.190025/) without Excel creating new sheets everytime I would click on a series. Also my data set has lots of fields. I'd only want to display a select few columns vs the all the columns in the dataset if possible. I could possibly group the columns I want to see right at the beginning of my source table if that's easier (ie. column range).
The chart below is in a regular sheet alongside a few slicers which work well as connected filters.
I'm a newbie so I'd appreciate any help. Thanks
I've created a power pivot and a power chart off of it as seen below. I have a source table with various columns, etc. I would like to be able to see the data set when I double click (or click or mouse up, etc) on the series. When I double click I get I get "we can't drill down here."
I would like to see the details in a separate sheet called "DrillDown" (just like in this post here: https://www.mrexcel.com/board/threads/pivot-table-drilldown.190025/) without Excel creating new sheets everytime I would click on a series. Also my data set has lots of fields. I'd only want to display a select few columns vs the all the columns in the dataset if possible. I could possibly group the columns I want to see right at the beginning of my source table if that's easier (ie. column range).
The chart below is in a regular sheet alongside a few slicers which work well as connected filters.
I'm a newbie so I'd appreciate any help. Thanks
