cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Scoobyrooba
Frequent Visitor

TRUE/FALSE Filtering was changed to 0 and -1 after uploading to Power BI Report Server

Hey All,

I have encountered something quite interesting that I cannot seem to find an explanation for. I created a simple formula that returned TRUE/FALSE depending on whether or not someone met requirements to test out of a course. I set the filters to TRUE to include only people that meet those requirements. I can then use that bar chart to filter other visuals based on test outs.

 

The dashboard was then published to a Power BI report server. When viewing these visuals I noticed they are returning (BLANK). When I then opened the dashboard from the report server web service, the dashboard was working correctly, everything was there. Didn't make a lot of sense considering I opened it from the same source.

 

I then checked the filters on the visuals and I found that the filter options of TRUE/FALSE have been replaced with 0 and -1, with -1 replacing TRUE. Does anyone know why this happened? If I open it in Power BI desktop and change the formulas to return 0 and -1 will that stay the same on the web service or will it just switch to something else?

 

Any insight would be appreciated.

1 REPLY 1
AllisonKennedy
Super User
Super User

@Scoobyrooba this is a strange one that I haven't seen personally, but if you search the web it is an ongoing issue with True/False fields. If you could change the simple formula to use 0, 1 or 0, -1 or even "x" and "y" so that it's either numeric or text, this should fix the problem. True/false is a very unique data type, only allows 2 values, and is often coded many ways, so with regular service updates it might cause this replacement. I can't guarantee, but changine to 0, 1 or 0, -1 should work more reliably.


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.