Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

jrrodriguez

Problem with Booleans in Power BI

Submitted by on ‎03-27-2023 02:13 AM

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

See more ideas labeled with:
4 Comments (4 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎03-27-2023 07:36 PM
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
‎03-28-2023 05:28 AM

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
‎11-06-2023 02:10 AM

Hi guys!

 

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

DataSupportTeam
Regular Visitor
‎11-06-2023 02:15 AM

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

Idea Statuses