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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors