Better support for SSAS MD formatting

[koenverbeeck1]

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.

[aaron29]

I'm really surprised one this one. It's going to look pretty unprofessional not to be able to show a percentage value as a decimal. On premise SSAS Customers are obviously taking a back seat.

[fbcideas_migusr]

This is also a problem for SSAS Tabular

[fbcideas_migusr]

The fact that this isn't fully supported by now is downright absurd. How on earth does Microsoft think anyone would adopt their product if simple format stings cannot be rendered?

[lprince]

This is also true with Dim fields. My DIM fields are rounding to two decimal places despite the cube format having many more.

[gabriel_ilarda1]

also, if you add ;;0 at the end of the format to display null values as zero this doesn't work. This an issue in direct query mode as you can't do any formatting in Power BI. You just have to accept what comes back from the cube which means null values will always be blank. Using import mode you can create a measure which does it in Power BI but I can't import becasue my data set is too large.

[fbcideas_migusr]

Slightly related: we have a calculated % measure in a multidimensional cube with format set to "Percent". When displayed on a data table in Power BI (we're using a LIVE connection) it CORRECTLY displays with a % format (e.g. 20%), however when that SAME measure is placed on a Chart control the tooltip and the Y-Axis INCORRECTLY display and show this as a numeric (i.e. "0.2" instead of "20%"). The fact that the calculated measure displays using the CORRECT format in the Power BI data table but then INCORRECTLY when switched to a Chart visualisation is inconsistent and obviously not by design. This also shows that the format for this calculated cube measure is obtained by Power BI, but it is not being consistently applied across the visualisations. The Table & Matrix visualisation display the % with correct format, but I haven't found any other visualisation that does.. This is a show-stopper for rolling out Power BI to our target audience (Execs, etc.)

[atkint]

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!

[atkint]

I fully agree with the comment below. Please please Power BI Team, fix this inconsistency: "Slightly related: we have a calculated % measure in a multidimensional cube with format set to "Percent". When displayed on a data table in Power BI (we're using a LIVE connection) it CORRECTLY displays with a % format (e.g. 20%), however when that SAME measure is placed on a Chart control the tooltip and the Y-Axis INCORRECTLY display and show this as a numeric (i.e. "0.2" instead of "20%"). The fact that the calculated measure displays using the CORRECT format in the Power BI data table but then INCORRECTLY when switched to a Chart visualization is inconsistent and obviously not by design. This also shows that the format for this calculated cube measure is obtained by Power BI, but it is not being consistently applied across the visualizations. The Table & Matrix visualization display the % with correct format, but I haven't found any other visualization that does.. This is a show-stopper for rolling out Power BI to our target audience (Execs, etc.)"

[gil_little]

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

[gil_little]

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.