Forum Discussion
Thousand separator using COUNT values
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 thous...
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.
This works for count. Thank you.
But what, if you wanna have a distinct count on a specific column?
Then you cannot just work with this additional column.
Anyony has a solution for that, other than creating a measure?
Hi Anonymous and Anonymous
In the Formatting Pane>Specifi column>Values>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.
