Skip to main content

Power BI

Needs Votes

Better support for SSAS MD formatting

Vote (182) Share
Koen Verbeeck's profile image

Koen Verbeeck on 14 Apr 2016 17:42:51

Power BI (Desktop) supports formatting designed in the SSAS cube. However, when I format a measure as \€ #,##0.00;\€ -#,##0.00, the € sign is lost in Power BI. It works in Excel though.

Comments (37)
Koen Verbeeck's profile image Profile Picture

Anil Kumar Khathraji on 06 Jul 2020 00:12:17

RE: Better support for SSAS MD formatting

Are you still considering this option to be built?

Koen Verbeeck's profile image Profile Picture

Stefan Schips on 06 Jul 2020 00:03:59

RE: Better support for SSAS MD formatting

We have SSAS MD in place for years, now evaluating Power BI vs. other tools for visualisation. We would like to use Power BI, but this is a real showstopper. I really cannot believe that such a bug is unfixed for such a long time. Please take care about the SSAS MD clients and fix this!

Koen Verbeeck's profile image Profile Picture

Matthew B Stelter on 05 Jul 2020 23:48:47

RE: Better support for SSAS MD formatting

Cannot format fields in SSAS MD in Power BI. Limits the usability of Power BI at my company

Koen Verbeeck's profile image Profile Picture

Supanut Sinphatsirikul on 05 Jul 2020 23:42:58

RE: Better support for SSAS MD formatting

Building reports for a leading Bank in Thailand but can't show them percentage values........

Koen Verbeeck's profile image Profile Picture

Filip Bouckaert on 05 Jul 2020 23:42:47

RE: Better support for SSAS MD formatting

Please fix, we get complaints about this

Koen Verbeeck's profile image Profile Picture

Martin Pachwald on 05 Jul 2020 23:42:47

RE: Better support for SSAS MD formatting

'@Power BI Team: Fix this teribble bug asap. It is unbelievable how you can have such a bug in a reporting tool.

Koen Verbeeck's profile image Profile Picture

Jeffrey Lai on 05 Jul 2020 23:42:23

RE: Better support for SSAS MD formatting

omg, how can this not be fixed yet!

Koen Verbeeck's profile image Profile Picture

Gil Power BI User on 05 Jul 2020 23:39:02

RE: Better support for SSAS MD formatting

Power BI needs to apply full SSAS MD FORMAT_STRING o all visuals - It's wrong that chart axes and values don't apply the SSAS FORMAT_STRING at all.

Koen Verbeeck's profile image Profile Picture

Gil Power BI User on 05 Jul 2020 23:39:02

RE: Better support for SSAS MD formatting

Or just let us override the format string in Power BI.

Koen Verbeeck's profile image Profile Picture

Arnould on 05 Jul 2020 23:18:31

RE: Better support for SSAS MD formatting

I forgot to add... The same inconsistency goes with sorted category names. It works correctly in a data table/matrix and the values are sorted according to the underlying cube sorting (i.e. seasons in our case). BUT it doesn't work in any charts. And since it is a MD cube, it doesn't have the option to customize the sort in the data modeling ribbon.

MS Team, please fix these huge issues that prevents rolling out this amazing tool!