Forum Discussion
Boolean converted to Integer on refresh in Service
We have a report with a slicer on a Boolean typed column which publishes as it appears in the desktop app, but changes to an integer type after the data is refreshed in the service. The first occur...
OwenMITP are you having issues with filters or with measures?
If you are having problems with measures, can you please double check if your DAX queries include something like:
IF([BooleanColumn] = "TRUE", X, Y)
IF([BooleanColumn] = "FALSE", A, B)If so, you could change your measures to use the boolean values of said columns instead of their literal value. Following the previous example, you could change your DAX measures to:
IF([BooleanColumn], X, Y)
IF(NOT([BooleanColumn]), A, B)
No issues with Measures, only with columns that show as boolean with values true/false in PBIX and -1/1 when published to powerbi web.