Don't show decimals for percent measures when Connect Live to Analysis Services Cube

[JohanEriksson]

Hi!

Does anybody know if it is possible to remove decimals for a measure that are shown as percent when data source is Connect Live to a multi dimensional cube?

Additional info:

The visuals I am using in the report I want to achieve this ares KPI and Matrix.

Even tough it is an external model for Power BI I manage to achive this for regular measures with Sum.

Best reagrds, Johan

[v-danhe-msft]

Hi @JohanEriksson,

Based on my test, could you have tried to use the Formatting function in the Modeling:

Or you could use the ROUND function:

Regards,

Daniel He

[JohanEriksson]

Thanks for the replies!

The problem is when using a model outside PowerBI (multidimensional cube) I am not able to do any formating or create any extra dax measures.

I was (or I still am...) hoping that there might be a generic configuration property in PowerBI or that I coluld solve problem by changing the FORMAT_STRING in Analysis Services which today is "Percent".

Regards, Johan

[Greg_Deckler]

Possibly by using FORMAT function?