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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KV2022
Helper II
Helper II

change summarization setting for a numeric field

Hi, I imported an excel file data  in service which has numeric fields summarized and sigma added automatically. Is there an option to change the summarize settings in Power BI service  similar to Desktop?

2 ACCEPTED SOLUTIONS

You can anytime download your file from the server make change and post it to the Service.Is there any problem in doing that ?

Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

View solution in original post

Hi, it should not be a problem. thanks.

View solution in original post

4 REPLIES 4
ribisht17
Super User
Super User

  @KV2022

Option is with Power BI Desktop not service

Inside Power BI Desktop: Click on the column you would like to remove summation; Click on the Modeling tab; Toggle Default Summarization to Don't summarize.

 

Thanks,

Ritesh

 

I  don't have a power bi Desktop file for the excel data. I am importing data from excel directly.

You can anytime download your file from the server make change and post it to the Service.Is there any problem in doing that ?

Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

Hi, it should not be a problem. thanks.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors