Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Problem with Booleans in Power BI

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.

Status: Investigating

Hi @jrrodriguez 

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

vyetao1msft_0-1679970731160.png

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @jrrodriguez 

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

vyetao1msft_0-1679970731160.png

Best Regards,
Community Support Team _ Ailsa Tao

jrrodriguez
Regular Visitor

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 Destkop FilterPower BI Service FilterPower BI Service FilterPower BI Desktop Calculated ColumnPower BI Desktop Calculated Column

DataSupportTeam
Regular Visitor

Hi guys!

 

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

DataSupportTeam
Regular Visitor

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