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