Reply
Visitor
Posts: 1
Registered: ‎01-31-2018

Re: Formatting SSAS values (Live connection/explore live)

[ Edited ]

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.

Highlighted
Member
Posts: 60
Registered: ‎11-12-2015

Re: Formatting SSAS values (Live connection/explore live)

Thanks for the info!

Frequent Visitor
Posts: 2
Registered: ‎03-02-2018

Re: Formatting SSAS values (Live connection/explore live)

^Bump ... Any resolution for this? 

Occasional Visitor
Posts: 1
Registered: ‎09-27-2018

Re: Formatting SSAS values (Live connection/explore live)

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?