Showing results for 
Search instead for 
Did you mean: 
New Member

Formatting SSAS values (Live connection/explore live)

I'm running into an issue where I'm not seeing anything that will allow me to format any values I'm pulling from a live connection to a SSAS multidimensional cube.


Values Example


I would like to format the date in any format in general (01/02/2015, Jan 02, 2015, etc...) and "Cost" would format as $31,519.43 or even $31,519.


Is this possible to do with a live connection to a SSAS data cube?


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.


Thanks for the info!


^Bump ... Any resolution for this? 

New Member

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?


Regular Visitor

 Any solution yet? I am not able to format the value from SSAS cube (live connection).......I just like to change decimal places from 2 to 1 on the percentage value.




Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors