Skip to main content

Power BI

Needs Votes

Better support for SSAS MD formatting

Vote (172) 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

cad0047a 8144-488a-aa01-397df2eb2697 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

458e560b 9977-4513-83cd-40e1cad4057b 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

7a5d8059 8b3a-4319-8d53-cdf1c7bc3c37 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

a5078d86 73db-4b5a-900c-e8caeedea3e0 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

24381326 6b73-415b-bbbc-dc66fcda1880 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

a29b87b1 af29-44cd-b460-f36c14d70950 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

08632b87 c877-409b-979c-9901477a7915 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

b7d54f5a 7f42-4902-97b1-f05511b368c4 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

b7d54f5a 7f42-4902-97b1-f05511b368c4 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

91e057df 24e3-4b91-9fa7-54d31719ee04 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!