SSAS live connection number format

[Anonymous]

Hello,

I am testing power bi with the adventure works multidimensional cube and the formtting of all the measure does not seems to work: I don't have the % (0.41 but i should have 41%), the $ sign is always missing...

When I have this problem in excel, I can activate the OLAP Server formting option. Is there any similar option in power bi ?

Thanks for your help

[pbyrne]

Does any one have an update on this issue?

It's causing me some major problems!  It appears that format options are disabled in Power BI when you connect live to a SSAS Tabular Model and that some of the visuals don't support some formats.  While it's certainly possible that I may be overlooking something, it appears that this combination of issues forces a decision to be made up front regarding how a numeric will be displayed and in which can be used to display that value.  This unnecessarily and severely restricts the creativity of the dashboard/report designer.  The only work around that I've been able to come up with is to define a seperate measure for each of the desired formats, which is over kill and unnecessarily bloats the tabular model.

Any suggestions?

[v-micsh-msft · Accepted solution]

Hi Ilocans,

"

Cell level Formatting and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.

"

This is listed as a limitation in the follwoing article:

Connect to SSAS Multidimensional Models in Power BI Desktop

To work around this, we could do the format in Excel, and then import Excel into Power BI Desktop.

Other data source such as SQL database, we could change the data format under reporting view, in the modeling tab.

Regards