01-31-2018 02:10 AM - edited 01-31-2018 02:16 AM
My experience is that the visualizations Table and Matrix actively uses "Standard" format string on measures that, in the source, are configured without format string. My expectation was "No specific format" (like Excel's "General"). To accomplish the thousand separator and skip decimal places, I set FORMAT_STRING = "#,##0"
Also, even though on live connection, I see that vizualizations like KPI provides the option to specify "Value decimal places" (Format > Indicator).
Hope this is helpful.
09-27-2018 01:47 AM
I am facing a similar issue:
with a live cube connection, i am having issues with thousand separator in random measures.
For example, for one specific measure, card visual shows numbers with the separator and line chart doesn't. (I have applied thousand separator format in the cube )
Any ideas please?