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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.

 

v-eqin-msft
Community Support
Community Support

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.

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors