cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

24 REPLIES 24
Highlighted

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

Thanks for the info!

Highlighted

^Bump ... Any resolution for this? 

Highlighted
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?

 

Highlighted
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.

 

czheng_0-1601344615728.png

 

Helpful resources

Announcements
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!

secondImage

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