Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Format Strings don't work on a SSAS Model with Calculation Group(s)

AAS recently implemented Calculation Groups with big fanfare. However any SSAS / AAS Cube that has *any* users using Power BI in Live Connect mode cannot add this feature to their cube. I would be willing to bet this is > 95% of all Microsofts Cube customers. The problem is that any graphical visual (i.e. not table/matrix/card) will not honour *any* format string (static or dynamic). This means that any simple measure that shows a % will show as a decimal 0.01 instead of 1%. This is such a jarring issue for users it means that we cannot use the great new feature because Power BI has only allowed Matrix and Table to honour the Format String as defined in the model I've contacted the support team and I'm told that the dev team are only expected to start working on this during this summer with no ETA. A real shame that Microsoft's flagship reporting tool cannot work with Microsoft's flagship OLAP database until then. Our users were looking forward to reducing the number of measures to 0.2 of what they were (sorry, that should be 20%, couldn't resist 🙂 )
Status: Completed
Comments
erpfau1
New Member

This is still an issue as of 2022-08-03 and should not be marked as completed.

fbcideas_migusr
New Member

Hello everyone, this problem has not been solved yet? I have the same problem...

geve01
New Member

Still the issue

fbcideas_migusr
New Member
Status changed to: Completed