Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am connecting to an Azure SQL Database and the View I am selecting has a column where the values are 1 or 0, when this is imported into Power BI Desktip and I view this in Power Query Editor the value is showing this TRUE or FALSE. Why is this, I have added a Custom column after this and it is not returning the correct results be it is looking for a 1 which is nver there. How do I just show it as 1 or 0 only?
Thanks
Hi @AvPowerBI ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Stephen Tao
Hi @AvPowerBI
If thee source column is 1's and 0's then someething in your PQ code is changing that to true/false. Checks the query steps to see what - look for stpes with names like Changed Type
Alternatively, chnage the type of the True/False column to Whole Number
Regards
Phil
Proud to be a Super User!
Hi @AvPowerBI ,
Are your results in logical(1/0)? If they are, try to change data type to True/False.
Otherwise, you could try to create a conditional column, then change the data type of the new column to True/False.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AvPowerBI
Did you try changing the data type to "Whole Number". It automatically converts it to 0 and 1
If I helped you solve your problem, please mark this as a solution!
Regards,
Veena Shenolikar
User | Count |
---|---|
128 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |