Forum Discussion
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_DecklerCommunity 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".
- jminrodNew Member
Thank you, Much easier than I thought. Very new to excel and power bi. Thanks again