I posted this issue on the PowerBI forum but someone there suggested I try posting it here as they were unable to reproduce my issue.
I have an Excel 2016 workbook (I'm using 64-bit Windows 10 and 64-bit Excel 2016) with a number of Power Queries off of a data table range. The output of several of those Power Queries are then used in Pivot Charts (each of which is located on its own sheet). This has been working fine for a month, but now I get an exception whenever I select one of the chart sheets.
I've created a minimum working example workbook from scratch (no relation to the workbook I've been using above, and with manually entered data) and I experience the same exception.
To create the minimum working example I typed the following data into the first sheet (called raw-data):
col1 col2 col3
row1 5 5 5
row2 5 2 5
row3 3 3 4
row4 4 5 5
row5 4 4 3
row6 5 5 2
row7 5 3 5
row8 2 4 5
I labelled the range
with the name "data", and then I selected Data ... Get & Transform Data ... From Table/Range and create a Power Query called "data-query-out" as follows:
I named the worksheet that this Power Query's output is placed on "transformed-data". I then selected Insert ... Pivot Chart and used "data-query-out" as the Table/Range input and chose for the Pivot Chart to be placed on a new worksheet. I named the Pivot Table sheet that is produced "pivot-data" and selected the checkboxes alongside each of the Pivot Chart Fields.
I then right clicked on the Pivot Chart and selected Move Chart, and selected New Chart, giving it the name "pivot-chart". I immediately get the following exception:
NOTE: in the following CODE segment I have had to replace < with |||--- and > with ---||| in order to avoid this forums overstrict html blocking.
I can still update the graphs once I've closed the exception dialogue, but whenever the charts are on their own sheet it will appear again when I reselect the tab, or when I open the graph element properties panel.
Anyone got any idea what is causing this issue, and how to fix it - I'd really appreciate your help?
Thanks,
PowerBIGuest
Bookmarks