cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
candy
Regular Visitor

Two decimal places - online/desktop figure

Hello, I have a few question about power bi online and desktop.

I have tried  power BI  online and desktop for my boss and their boss! That's great! 

Q1: But there's few questions. 

      I want the number in figures  will be two decimal places…. How can I set it? Could I set it for figure as I need only two decimal places show? (No need to change raw data excel files)

 

Q2: As I change the raw number for all two decimal places,  the desk top seems to be OK. 

   But how come when it be published to online

   I publish to online version, then it turned to be 999.08 => 999.079999999999

   Desk versionDesk versionOnline version (desktop publish)Online version (desktop publish)

Could you help me, my boss and their boss hope it will be clear number QQ(two decimal places)

 

Thank you so much!  Smiley Happy 

BR

Candy

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

Hi Candy,

 

You can set the data type for your column either at query stage or after loading to PowerBI. As shown in the screenshot, go the Table View on the left side of the screen, Go to the Modelling Tab, and Select your desired column, Select the Fixed Decimal number with the precision of 2 decimal points. This will set the data type required for your column.

 

Fixed decimal number with precision of 2 decimal pointsFixed decimal number with precision of 2 decimal points

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

2 REPLIES 2
BhaveshPatel
Community Champion
Community Champion

Hi Candy,

 

You can set the data type for your column either at query stage or after loading to PowerBI. As shown in the screenshot, go the Table View on the left side of the screen, Go to the Modelling Tab, and Select your desired column, Select the Fixed Decimal number with the precision of 2 decimal points. This will set the data type required for your column.

 

Fixed decimal number with precision of 2 decimal pointsFixed decimal number with precision of 2 decimal points

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

BhaveshPatel
Community Champion
Community Champion

Hi Candy,

 

You can set the data type for your column either at query stage or after loading to PowerBI. As shown in the screenshot, go the Table View on the left side of the screen, Go to the Modelling Tab, and Select your desired column, Select the Fixed Decimal number with the precision of 2 decimal points. This will set the data type required for your column.

 

Fixed Decimal Number with 2 decimal precision.Fixed Decimal Number with 2 decimal precision.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors