Forum Discussion
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 numbe...
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.
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 |
| 9 | 0.86% |
| 3 | 0.29% |
| 4 | 0.38% |
| 6 | 0.58% |
| 9 | 0.86% |
| 11 | 1.06% |
| 6 | 0.58% |
| 2 | 0.19% |
| 12 | 1.15% |
| 14 | 1.34% |