Skip to main content
cancel
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

Reply
Anonymous
Not applicable

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

@Anonymous 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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors