cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
runecfoyn Frequent Visitor
Frequent Visitor

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

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
dataguy Member
Member

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

Thanks for the info!

v-joto Frequent Visitor
Frequent Visitor

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

^Bump ... Any resolution for this? 

Kab86 Occasional Visitor
Occasional Visitor

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?

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 140 members 1,934 guests
Please welcome our newest community members: