How can we improve Power BI?

Better support for SSAS MD formatting

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.

139 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Koen Verbeeck shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

35 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Martin Pachwald commented  ·   ·  Flag as inappropriate

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

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Arnould commented  ·   ·  Flag as inappropriate

    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!

  • Arnould commented  ·   ·  Flag as inappropriate

    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.)"

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.)

  • GI commented  ·   ·  Flag as inappropriate

    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.

  • Laurisa Prince commented  ·   ·  Flag as inappropriate

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

  • Hikmer commented  ·   ·  Flag as inappropriate

    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?

  • Matthew Chapman commented  ·   ·  Flag as inappropriate

    Since formatting from SSAS MD cubes does not come through on stored calculated members I'm trying to get around this by building calculated members. For example:

    CREATE MEMBER CURRENTCUBE.[Measures].[Units Sold %]
    AS
    CASE
    WHEN [Scenario].[Scenario].CurrentMember = [Scenario].[Scenario].&[2017 Actual+Orders vs 2017 Budget]
    THEN
    DIVIDE(([Scenario].&[2017 Actual+Orders vs 2017 Budget],[Measures].[Units Sold])
    ,([Time].[Year Nr].&[2017],[Scenario].[Scenario].&[Budget],[Measures].[Units Sold]))
    ELSE NULL END
    ------------------------------------------
    ,FORMAT_STRING = "Percent"
    ,VISIBLE = 1
    ,ASSOCIATED_MEASURE_GROUP = 'Measures'

    This returns a value that is formatted as a percrent but then I get more columns than I want such as "Units Sold %" under scenarios not referenced in the calc above. I tried switching off the automatic column width and hiding the column but then the table doesn't refresh.

    Is there a way I don't know about that will enable me to hide the extra columns with no values?

  • James commented  ·   ·  Flag as inappropriate

    We are starting to look at SSAS with Power BI for some of our BI needs. Its extremely important that we can inherit the formatting as specified using the formatting strings in the SSAS measure design.

    Please work on incorporating this into an upcoming release of Power BI.

    I'll try using the workaround as suggested by Chris Webb

  • Aaron commented  ·   ·  Flag as inappropriate

    Best work around I've found. And from the infamous Chris Webb. Trying his workaround now.

  • Aaron commented  ·   ·  Flag as inappropriate

    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.

  • Cray Kuo commented  ·   ·  Flag as inappropriate

    Supporting SSAS MD Formatting is a must have.
    Without the feature will clearly impacts the user adoption of PowerBI + SSAS.
    Also, it will be nice to have the ability change the formatting directly in Power BI.

← Previous 1

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.