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
    6 years ago

    Hello Pragati11 ,

     

    If helps, the problem is that the format string expression in a calculated item doesn`t reflect in Power BI Desktop when using a measure created in Power BI, but the format works when using a SSAS measure:

     

    Format Expression in SSAS:

     

    The issue in PBI format:

    Thanks

     

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      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