Default sum (Sigma)

[jminrod]

I have a table that I built that is daily production for employees. When I bring the table into bi the Operation code defaults with a sigma logo and the entries show in reports as sums. But I need the code to be just the code so I can add a slicer and see who runs better based on operation. I get the same exact thing with all of my efficiencies. They are decimals when i bring them in which are percentages for run and set up efficiency. They appear as decimals when I bring them in but bi converts those to sums. I was hoping someone on here could point me in the direction of the best way to fix this as well as learn about. Youtube or links to a site would be helpful unless I am missing something stupid. Thanks, Jim

[Greg_Deckler · Accepted solution]

Select your column in the data model and then on the Modeling tab, in the Properties area of the ribbon select Default Summarization and "Do Not Summarize".

[jminrod]

Thank you, Much easier than I thought. Very new to excel and power bi. Thanks again