Thousand separator using COUNT values

Question

I have two tables: One displaying the SUM of values, the other the count of values.

I can only manage to show thousand separator for the table with SUM of values.

When using COUNT there is no thousand separator.

Any idea how to solve this problem?

juan_pablo · Answer

Hi&nbsp;Anonymous&nbsp; and&nbsp;Anonymous&nbsp;In the Formatting Pane&gt;Specifi column&gt;Values&gt;Value decimal places, enter 0 decimal places instead of "Auto" and that will display the thousand separator.It's a very un intuitive way of doing it but Power BI has never fix it.&nbsp;&nbsp;&nbsp;&nbsp;

sturlaws · Answer

hi Anonymous,&nbsp;have you created a measure or are you just pulling in a column to the vaue field? If the latter is the case, then the formatting of the column have no impact. Try creating a measure, number of cases = count(caseID), and format the measure according to you need

anonymous · Answer

OK - i made a work around myself.I made a column with the name antal (Danish for count) with the value of 1.And dragged it into the value field and choosed SUM.&nbsp;&nbsp;

anonymous · Answer

The collumn is just pulled in the vaue field. Then i can choose SUM, AVG, COUNT etc.But the thousind separator is only there, when i choose SUM.In excel there is no problem.&nbsp;The work around you suggest is cumbersome in my case.I think it should be easy to format everything in the value field. Like in excel.Numbers wiht more than 5 digits can be hard to overlook - the reasion for the separator :-)&nbsp;

sokg · Answer

hi Anonymous&nbsp;&nbsp;select the field and click at the red cickle&nbsp;

Forum Discussion

Thousand separator using COUNT values

8 Replies

Related content

Thousands Separator

Thousand-Separator-and-Decimal-Separator

Thousand separator

Data label - Thousands Separator - bug?

Thousand Separator and Decimal Separator