Error message not showing in chart?

[#1]

Hi,

Acn anyone let me know why the message is not showing. I don't want to supress zero values or supress missing values.

I would need to show if there are no values it should populate as 'No fail'

Dimension: Error Code

Expression : If(Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID))=0,'No Fail',
                      Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID)))

Thanks.

[#2]

Please see attached.

[alexandros17]

Uncheck "exclude zero values" check box

[#4]

Thanks. where can I uncheck this in bar chart?

[MK_QSL · Accepted solution]

Go to dimension tab and select show all values

Go to Expression tab and untick Show values on datapoints

Now copy the same expression and create a 2nd expression

Untick Bar and Tick Text on axis..

[alexandros17]

right click on the object  -> properties

presentation tab -> suppress zero values

[#7]

Thanks. It is looking messy in the chart Is there anything I need to change?

[MK_QSL]

GO to presentation tab

Chart Scrolling

Tick Enable X-Axis Scrollbar

when number of items exceed (10 or whatever you want)

[sudeepkm]

You may have to use a scroll bar enable in your chart due to huge data points.

Please take a look at the attachment. As Manish suggested Text on Axis is your solution.

[ashwanin]

hi, Your expression is ok,

You just need to Check the 'Text on Axis' under Chart -->presentation tab.

I checked it and found the it reflects