Greetings all - long time reader, first time poster!
I notice PowerPivot doesn't handle slicers resulting in no data in charts as well as regular pivot tables.
Basically, when choosing a slicer option that results in no data, the whole chart disappears - no axis line or label, chart titles, nothing. I can't use the show all rows/columns options on the pivot table, as it displays too much info.
To get around this, I tried using a text box on a cell using an Isblank formula to display as an alternative message, explaining to the end user that no data exists. Works fine, until you use this pivot in Sharepoint, as text boxes aren't supported.
So, to cut to the chase - how can I display a message to end-users in Sharepoint explaining the reason the graph has disappeared?
I notice PowerPivot doesn't handle slicers resulting in no data in charts as well as regular pivot tables.
Basically, when choosing a slicer option that results in no data, the whole chart disappears - no axis line or label, chart titles, nothing. I can't use the show all rows/columns options on the pivot table, as it displays too much info.
To get around this, I tried using a text box on a cell using an Isblank formula to display as an alternative message, explaining to the end user that no data exists. Works fine, until you use this pivot in Sharepoint, as text boxes aren't supported.
So, to cut to the chase - how can I display a message to end-users in Sharepoint explaining the reason the graph has disappeared?