Chart widget functioning wierd...

Andrew Stills

I have a report showing calculated numbers in 3 columns. The numbers come from the summary sheets on various project files. Other than the sheet name these are the only columns in the report. Trying to use the pie and donut charts it says they are not available for this data set. Trying to select the columns it only shows the last column (no matter how many are actually in the report), however, the all data is displaying in the chart?

Anyone know why this might be occurring and how I could get this to allow for a pie/donut chart.

Also, it's worth noting this same chart using the same fields will work on the individual project dashboards.

Genevieve P.

Hi @Andrew Stills

Would you be able to post screen captures of what you're seeing?

If this same Report is working on other Dashboards without an issue, I would try some basic troubleshooting to start (logging out/in, trying a different browser, selecting a different sheet for the source then selecting the Report again, creating a copy of a different chart widget and finding the report from the copy instead of creating new or vice versa, etc).

If none of this works, it would be useful to see a screen capture of the Report and a screen capture of how it looks like in the pop-up window from the Chart widget (but please block out any sensitive data).

Thanks!

Genevieve

Genevieve P.

Hi @Andrew Stills

Would you be able to post screen captures of what you're seeing?

If this same Report is working on other Dashboards without an issue, I would try some basic troubleshooting to start (logging out/in, trying a different browser, selecting a different sheet for the source then selecting the Report again, creating a copy of a different chart widget and finding the report from the copy instead of creating new or vice versa, etc).

If none of this works, it would be useful to see a screen capture of the Report and a screen capture of how it looks like in the pop-up window from the Chart widget (but please block out any sensitive data).

Thanks!

Genevieve

Andrew Stills

Genevieve,

Thanks for looking at this. I've discovered this also goes back to another discussion I started regarding data pulled from Summary Sheets. When I originally posted this I was not thinking the two issues were related.

Please fell free to look at the other discussion to see if you might have any input.

https://community.smartsheet.com/discussion/71583/cant-pull-report-of-summary-sheet-fields-into-power-bi-using-connector-or-excel-using-live-data#latest

Thanks,

Andrew