Paginated Report Indicator is Reporting "out of range"

[djanszentql]

I have an extremely simple PBI Paginated report, which has a table in it containing a column for "isFailed".  This column is a bit field in my database so it is either 0 or 1.  I added an indicator to replace this column, chose my icon set, and then made the following as my range:

However, on my report it is just showing as a blank.  Is this because the field is a bit and not an integer?

[amitchandak]

@djanszentql , can check if there is an option Like boolean in state of measurement and use that?

[djanszentql]

I do not see boolean as an option.

[djanszentql · Accepted solution]

I wrote an IIF function and set the value.  It seems to have worked 

[v-yingjl]

Hi @djanszentql ,

Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Community Support Team _ Yingjie Li