Forum Discussion

jminrod's avatar
jminrod
New Member
10 years ago
Solved

Default sum (Sigma)

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

 

 

 

  • 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".

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
      jminrod
      New Member

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