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

Power Bi Table number formatting

I am creating a simple Table in Power BI and trying to get rid of decmials but cant seem to find an option fo number formating anywhere, i can Edit Query and change the format but it rounds off numbers incorrectly and even after that Table visual will not remove 2 decimal places. I dont think Microsoft can oversee this very very basic feature.

 

Also how do i sort a table in the table (1st column in the screen shot).

Power BI screen shot.JPG

12 REPLIES 12
Highlighted
Super User IX
Super User IX

Re: Power Bi Table number formatting

In Data view, choose your table, choose your column and on the Modeling tab where it says "Auto", (Formatting section) edit this to be 0.

 

In report, select table, click on the column you want to sort, if it is sorted the wrong way, click again. You can also set a "Sort By" column if you need a special type of sorting.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: Power Bi Table number formatting

thanks for the reply, sorting worked out fine.

 

Table is still not formating properly, screen shots below:

1st screen shot is the table and 2nd screen shot is formatted column from the data tab.

data format.JPGdata format.JPG

Highlighted
Regular Visitor

Re: Power Bi Table number formatting

formatting worked too, i had to drop and include the Measure again on the table,
thanks for your help

Highlighted
Advocate I
Advocate I

Re: Power Bi Table number formatting

Hello @Greg_Deckler

 

I have updated my model and set the decimal to 0. After doing that my model is getting currepted.

 

Is there any way to overcome this?

 

Thanks in Advance

Shruti Vyas

 

Highlighted
Advocate I
Advocate I

Re: Power Bi Table number formatting

Yep.  You're an allstar @smoupre

Highlighted
Regular Visitor

Re: Power Bi Table number formatting

Found this solution while trying to figure out the decimal places.  One thing I'm perplexed about though.  I am wondering how this can be done on a column that you are showing as a percent of the total such as below.  How do I adjust this to a single decimal place?  

  

Total% Total
90.86%
30.29%
40.38%
60.58%
90.86%
111.06%
60.58%
20.19%
121.15%
141.34%
Highlighted
Frequent Visitor

Re: Power Bi Table number formatting

See Display units and precision control for table & matrix columns in Power BI Desktop March Feature Summary.

 

 

 

Highlighted
Regular Visitor

Re: Power Bi Table number formatting

I have the same issue but when i go to modeling tab the formatting section is all greyed out and won't let me select anything?

image.png

Highlighted
Anonymous
Not applicable

Re: Power Bi Table number formatting

where do i find the "data view"?

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors