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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ArslanCloud
Regular Visitor

Summarization/Sigma Symbol is missing, I can't Summarize any Column

Hello,

I have many tables in power BI Desktop. i don't Know how all the tables Dataset miss the Sigma Symbol. If i used any field in Card it does'nt Show any value. For furthure information i attach Some SS. Community 2.pngpower bi comunity.png

8 REPLIES 8
PunChili
Helper I
Helper I

After creating a calculation group the summarizing symbol disappeared with this feature it was possible to make it visible again 

PunChili_0-1731259579712.png

 

PunChili
Helper I
Helper I

Dear all,

 

someone find something? Today I recognized a similar behavior on another table. I opened the existing custom semantic model in fabric. I added a new table to the model in fabric. Then I added a relationship which pointed not correctly many to one, but one to many. After I corrected this issue, the sigmas appeared again.

PunChili
Helper I
Helper I

hello,

 

does anyone know if there is a solution of this issue? I encounter it on on one semantic model, having also numeric datatypes, but in the report it is not showing up and can't be used in visuals.

 

Please let me know about your findings and if there is solution to this bug?

 

Thx.

Idrissshatila
Super User
Super User

Hello @ArslanCloud ,

 

it may be because the column type isn't a number type.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Column Type is Also number. I have 17 tables in my dataset all the numeric fields miss the sigma value. 

 

@ArslanCloud , so what's the issue with missing the sigma, aren't they aggregating when adding into a visual ?



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




yes is it show nothing in visual and in card column  is not pasted 

@ArslanCloud , it seems to be a bug, to make it work just create a measure that would sum or count your column depending on what you need to show.

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.