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

Format values in Table

Hi,

 

I used the <table> under visualizations to get a summary result.

I am wondering if there is a way to format the values of count, total and percentage? 

i.e. format count and total w/ a thousands separator, making 5189 = 5,189 and display percentage up to 1 decimal place.

They are not created measures; therefore, I am not able to apply the formats.

 

Thank you in advance for the support!

 

table.png

1 ACCEPTED SOLUTION

Accepted Solutions
pxg08680 Member
Member

Re: Format values in Table

@lindseyhuang

To make the Percentage values to 1 decimal, Select the column that you are using to display in the table. Go to modelling pane on top and in formatting increase the decimal to 1 instead of auto.

a1.PNG

 

For other issue I did not get what you are trying exactly. Do you want the TOTAL  displayed at the end of table to be separated accordingly  or each value in column Count or Total to be separated accordingly.

2 REPLIES 2
pxg08680 Member
Member

Re: Format values in Table

@lindseyhuang

To make the Percentage values to 1 decimal, Select the column that you are using to display in the table. Go to modelling pane on top and in formatting increase the decimal to 1 instead of auto.

a1.PNG

 

For other issue I did not get what you are trying exactly. Do you want the TOTAL  displayed at the end of table to be separated accordingly  or each value in column Count or Total to be separated accordingly.

v-ljerr-msft Super Contributor
Super Contributor

Re: Format values in Table

Hi @lindseyhuang,

 

Have you tried the solution provided by @pxg08680 above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards