Is there a way to change the background colour when an error message shows?

[#1]

I have a dashboard with about 20 charts and if various selections are made not all the charts will give a result - so the error message pops up.

I know it is only cosmetics but the error message is on a bright white background so your eyes are drawn to that rather than the charts which actually have meaningful data.

[#2]

Had the same problem myself - the error message look rubbish in white if you're using a dark background and there doesn't seem to be a way of setting this in the chart properties.

The workaround I used was to apply the "conditional show" on the chart.  For example if your chart expression is "sum([Sales Amount])" then appy a conditional show of "= sum([Sales Amount]) > 0".  This way if the chart value is 0, it won't appear at all.  You can then use a text box with the error message in the same place as the chart but with a conditional show of "= sum([Sales Amount]) <= 0".  The text box will allow you to change the background colour.

Crude but gets the job done.

[#3]

Hi Michael

Thank you for replying

I've got the text box appearing and disappearing according to the value but the chart shows "Calculation condition unfullfilled".

Do you have an example you can send me?

I assume this would not work if the chart is in a container.

Appreciate the help!

Cheers

[#4 · Accepted solution]

Hi Andy,

You don't need to use the calculation condition setting for this.  The attached example has an inline table with sales for 4 regions - north, south, east and west.  The pie chart is using an expression to show sales by region except for "West".  I have used the conditional show expression on the chart to make it disappear when the sales <=0.  There is a text object (in exactly the same position) with the opposite condition.  Therefore when you filter on region of West, the chart disappears and the text box appears.  The text box has the same colour as the sheet background so you don't get the default white box.

Not sure about containers but it should work exactly the same - just put the conditional show condition on the container.

Hope this helps.

Mike.

[#5]

Nice one Mike!