Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The formatting defined for an MDX Cube calculated measure from an SSAS cube is not being followed when displayed in the Matrix visualization in Power BI. Two decimal points are being displayed whereas formatting defined in the cube indicates NO decimal places.
This is using SSAS Direct connect mode.
My SSAS cube has been built with Visual Studio 2015 Version 14.0.25420.01 Update 3. It is running on SQL server analysis services version 3.0.4206.0.
Please test this behaviour against an SSAS cube in direct connect mode. You will have to create a calculated measure in the Calculations tab of the Cube designer and make it a similar type of measure. Meaning a measure sliced by a dimension member.
1. Firstly below is the cube calculation and formatting definition
2. Next Excel showing the measure correctly with No decimals
3. Lastly the Matrix visualisation showing the measure with 2 decimals places. Note there is no optional available to format this display to NO decimal places.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.