Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculation Group Format Expressions doesn't working with PBI measures

Hello everyone,    I'm currently using a PBI live connected in a Azure Analysis Services Tabular Model, in this model I have a calculation group with some calculation items in decimal format and ot...
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    You need to chnage the data format of your measure in Power BI.

     

    Click on your measure in FIELDS Pane, then on the top ribbon, chnage it to PERCENTAGE as shown in the screenshot:

     

    By Default, number of decimal places is 2, you can modify it to your requirement.

     

    Thanks,

    Pragati

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Well, the solution is not a solution. When using Calculation groups for Time Intelligence, the Benefits of dragging in a measure and having 3 Columns for one measure are null, if i format the measure as a percentage.

For example:

Selectedmeasure = > Revenue = Sum(Revenue)

Calculation Groups: 

  1. Current = Selectedmeasure()
  2. Previous Year = Calculate(Selectedmeasure(),Sameperiodlastyear(DateColumn)
  3. YOY % = [For Simplicity]: Divide ( Current; Previous Year) -1 

When using such a calculation group, the used measure Revenue is not a percentage, but a Number. The Formatting is done within the calculation group. 

When using SSAS Measures (Mesures created in the SSAS Model) the formatting is fine.

When using PoweBI Measure (Measures created in the pbix File and therefore local model) the Formatting of the calculation group is NOT APPLIED.