Forum Discussion
How to format data from Analysis Services (Live Connection) with comma (,)
Hello everyone,
I want to make value formatted with comma (,) like 3,000.5 from 3000.5 etc.
It works with DirectQuery or Import, but with Live Connection (Analysis Services) formatting % , grayed out.
How can I do that?
Thanks in advance,
Vladi
You have to format it in the Analysis service model itself.
An alternative option is to create a new measure in Power BI using the Analysis service field and format this measure in Power BI. But this is not recommended since it is creating the duplicate.
You need to do it at SSAS level,
Click on the measure in the Visual Studio and go to properties and set the FormatString Accordingly using Regular Expressions
3 Replies
You have to format it in the Analysis service model itself.
An alternative option is to create a new measure in Power BI using the Analysis service field and format this measure in Power BI. But this is not recommended since it is creating the duplicate.
You need to do it at SSAS level,
Click on the measure in the Visual Studio and go to properties and set the FormatString Accordingly using Regular Expressions
PbiCeo , refer the text of the topic,
also, check if this option is available
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
