cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors