Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 others in percentage format ("0.00%").

 

The issue is that when I use the calculation group with measures created in Power BI Desktop, the percentage formation doesn't work properly. It only works when I use the calculation group with measures created inside the tabular model in SSAS. Anyone facing the same problem or with any tips?

 

Thanks in advance

1 ACCEPTED SOLUTION

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:

Pragati11_0-1598972537009.png

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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.

 

Anonymous
Not applicable

Hi @Anonymous ,

As  @Pragati11  said , you just need to click the measure in Field pane firstly ,and then set the data type of the measure as “%, change the number of decimal places shown for this value into 2in Formatting tabs like this:

9.2.1.1.png

Did I answer your question ? Please mark my reply as solution.

If not, please upload some insensitive data samples and expected output.

 

Best Regards,

Eyelyn Qin

amitchandak
Super User
Super User

@Anonymous , I saw a similar post. But not sure you or someone posted a few days back. Seem like this is by design.

 

But check for an issue: https://community.powerbi.com/t5/Issues/idb-p/Issues

or an idea - https://ideas.powerbi.com/ideas/

 

I saw is something around tabular editor 3, not sure it is possible with that.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Pragati11
Super User
Super User

Hi @Anonymous ,

 

You will have to add more detail on why this is not working on a measure calculation.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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:

GustavoSantana__2-1598971633437.png

 

The issue in PBI format:

GustavoSantana__3-1598971814538.png

Thanks

 

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:

Pragati11_0-1598972537009.png

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.