Problem with Booleans in Power BI

[jrrodriguez]

When create a Boolean column in Power BI Desktop, the values are "True" or "False", but when push the document to Power BI service, de values are "0" or "1", causing that the filters used in Desktop version, returns no data in Power BI Service.

[Anonymous]

Hi @jrrodriguez 

I created a simple sample, but it does not appear as you said, can you provide your sample for us to test ?

Best Regards,
Community Support Team _ Ailsa Tao

[jrrodriguez]

I can only reproduce with my actual dataset (linked from sharepoint), I send you photos, but is imposible to send the entire pbix because of confidential data.

Power BI Destkop FilterPower BI Service FilterPower BI Desktop Calculated Column

[DataSupportTeam]

Hi guys!

Have you foung the solution for this issue?
I'm facing the same problem.

[DataSupportTeam]

I've just found that the solution is to set the column as type equals logical.

[Sourabhp]

Here is how the issue can be reproduced: 1.First create conditional column in Power Query which will return either true or false. 2.Set this column data type as logical or do not set any data type explicitly. 3. Add this column as a visual level filter in filter pane, select one value, true/false. 4. Publish the report to workspace and start the refresh. 5.Once refresh completes, open the report and the visual on which you have applied filter will go blank. Solution: I ended up converting some columns to text data type within power query itself. For few columns instead of using true/false I have used 1 and 0 and data type as whole number. I think only power bi service is has this issue. Report on desktop works fine even after refresh. I have faced this issue multiple times, I hope this gets resolved soon.