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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
f1254lipm
Frequent Visitor

Poor performance of calculation groups format string

Hi,

I have a problem with slow performance when using calculation group formats from tabular model in SSAS 2019. I have a pivot table with 3 measures and when I was using just the measures the performance was good.

Then I had the requirement to add the ability to change the format or units of values by selecting the format in a filter so I created a calculation group with one item per format and defined all items as SELECTEDMEASURE() and defined the required format strings into Format string expression. This is the article from sqlbi about this approach but I used much easier expressions just hardcoded formats like "0.00" https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/

Then I added that calculation group into a filter of the pivot table and the calculation group works as expected: when I select for example two decimals in the filter the measures are formatted as two decimals etc. but the format change takes at least a minute sometimes many minutes. This leads to the report being unusable. Are there some ways to improve the performance or different techniques for dynamic formats with the same functionality but better performance? The solution needs to be compatible with Excel.

Thank you for your time,
Filip

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @f1254lipm,

It sounds like you faced the performance issue to process the Dax expressions.

For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @f1254lipm,

It sounds like you faced the performance issue to process the Dax expressions.

For this scenario, I'd like to suggest you try to use t-SQL query to do apply formal operations, they should not affect getting data and refresh performance. (live connection mode seems not support to use t-SQL statement, perhaps you can try to convert it to direct query mode to enable this on data connector)

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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