Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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".
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".
Thank you, Much easier than I thought. Very new to excel and power bi. Thanks again
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |