Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
My data has a currency column that currently contains only whole dollar values, but the data might have decimal values in the future. In the Power Query Editor, I set it to Fixed Decimal, but when I Close & Apply, that field it set to "Auto" on the decimal places and shows no digits to the right of the decimal point. Essentially, I want to set the number of decimals in the Power Query Editor. Can I do that or must it only be done in PBI?
Solved! Go to Solution.
Hi @Syndicate_Admin ,
In Data view-->Click column-->Column tools tab to change:
Or in Model view-->Click the column-->Properties pane
Both of them need to be done in Power BI not in Power Query.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
In Data view-->Click column-->Column tools tab to change:
Or in Model view-->Click the column-->Properties pane
Both of them need to be done in Power BI not in Power Query.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Syndicate_Admin Hi!
You can only do it in Power BI with the box in Colmn Tools as you have written.
B.