Checkbox does not work

[Bumbar14]

Why I can not add checkboxes? I get the the error despite my data/configuration being OK (at least I think so). Any idea why it does not work?

[GavinW]

Is it possible that there are values other than 'true' or 'false' in the field (Financing) that you are filtering on? Are there any dimensions or measures with a red background in the 'Chart' setup area on the right? You will need to check each chart.

[Bumbar14]

I created a new parameter (see picture below) and inserted it on the blank page. I immediately got this error. Then I created a calculated field that considers this parameter and inserted a table. The table is calculated based on the ON/OFF property of the field, but the checkbox still gives me an error. So, to answer your questions there are no red dimensions or measures.

[GavinW]

Thanks for the context - if you update the data type of the parameter to 'string', does the error go away?

[Bumbar14]

No, the error does not go away. In fact, it is now red (see the attached picture) so I assume this is an incorrect data type for checkbox.

And I get this error

[GavinW]

If you click on 'see details' in the actual parameter box on the dashboard, is there anything helpful there?

Also, I am wondering what are you seeking to achieve with the parameter here?

[Bumbar14]

If I click on "see details" there is nothing helpful. Just a below error message

I want to build cash flow scenarios. One scenario would be if the financing is enabled, it would change the amounts. The calculation works (see the images below - if I set the parameter's default value and save it, the calculated amounts change). Still, I can not get a checkbox working for any boolean parameters.

[benjamin_b]

Did you manage to solve this or found some work-around? I'm having the same problem. I want the user to be able to select some boolean parameters that I then use in my big query data source.

EDIT:

My workaround was to use a text-parameter instead, setting two allowed values true/false strings. Then use a drop down list control instead. Then in my big query data connector I cast it to a boolean value like CAST(@my_string_param AS BOOL).

I did notice that the checkbox works if I connect to a big query view instead of using a custom query though.. But then I can't use my parameters.

[Bumbar14]

No, I did not find a solution. I gave up and did the same workaround as you.