Live SSAS on-prem multi-dim percentage format status?!

[Anonymous]

Hi, does anyone know if there is a way to format a KPI/measure as percentage in Power BI Desktop when using a Live SSAS on-prem multi-dim connection?

kind regards,

naj

[v-qiuyu-msft]

Hi @Anonymous,

When connecting to SSAS multidimensional model live, we are not able to format measures in Power BI desktop. See: Limitations of SSAS Multidimensional Models in Power BI Desktop.

Cell level Formatting and translation features are not supported in this release of SSAS MD.

Best Regards,
Qiuyun Yu

[Anonymous]

Hi @v-qiuyu-msft, thank you for the reply! Would you (or anyone else) happen to know if cell level formatting to SSAS MD live is coming/planned for an upcoming release of Power BI desktop/service?

kind regards,

naj

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Currently, I don't heard any news about this feature. But there is idea about create a measure in live SSAS cube by PG: Calculated measures when live connected to MDX cubes. Once this feature is available, you can create a calculated measure from orignal KPI/measure and specify data format. You can vote it up.

Best Regards,
Qiuyun Yu

[LKoewing]

Change the formatting of your calculated measure coming from your Multi Dimensional cube from "Percent" to "#.##%" for example, and test.