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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Missing sigma symbol

Hi!

I am really new to Power BI, so I am not familiar with all the terminology, so please bear with me if I have a hard time understanding something that might be easy!

So I am working with a data set and one of the aspects of it is called "depositie" (as can be seen in the image) with regards deposition values. It no longer has a sigma values but I do need that in order to work with it. Is there an easy way to get it back?

Thank you so much!

 

DMM20_0-1682927709202.png

 

1 ACCEPTED SOLUTION
bcdobbs
Community Champion
Community Champion

The sigma sign indicates that an implicit measure is available. Power BI will automatically sum or average values in a numeric column. If the sign is not present it would indicate that Power BI thinks the column isn't numeric. I'd check what data is in the column and go into power query (transform data) and set the type of column to be a numeric type.



Ben Dobbs

LinkedIn | Twitter | Blog

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

View solution in original post

2 REPLIES 2
bcdobbs
Community Champion
Community Champion

The sigma sign indicates that an implicit measure is available. Power BI will automatically sum or average values in a numeric column. If the sign is not present it would indicate that Power BI thinks the column isn't numeric. I'd check what data is in the column and go into power query (transform data) and set the type of column to be a numeric type.



Ben Dobbs

LinkedIn | Twitter | Blog

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

That worked, thank you so much!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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