Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @naj,
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
Hi @naj,
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
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
Hi @naj,
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
Change the formatting of your calculated measure coming from your Multi Dimensional cube from "Percent" to "#.##%" for example, and test.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.