The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
When Power BI imports data from Excel, the original sort is lost, and some columns get summed when all need to be left alone.
How do I prevent Power BI from doing this?
Solved! Go to Solution.
Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize.
If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.
- choose modeling tab
- select you field
- on default summarizatio, click drop down arrow next to sum and choose "don't summarize"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
When you drop a numeric field, it gets aggregated by default mainly SUM, and you can change it to "don't summarize", if you can share some more details, like screen shot, it will help to provide better answer.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Could not locate "Don't Summarize" setting described. Unfortunately, cannot provide screenshot.
There is no such setting in the cotntext menu for the item in the Fields section (right side bar), nor in the context menu in the Field heading in the main area. Trying "Edit Query" gets me the response "No Query Found".
My steps so far ...
1. Import tab from an Excel file into Data table
2. Create table DataWithCalculations by using DAX formula DataWithCalculations = Data
3. Add calculated columns to DataWithCalculations
4. Creating next table, DataWithCalculationsPivot, where I want to have 5 of the columns grouped, and the remaining columns summed.
I'm stuck with steps 3 and 4 and cannot get past. Step 5 would be like step 3, and step 6 would be like step 4. At this point is where I would begin to build the report.
here is screen shot for you , although I'm still not clear about your requirement:
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Yeah, I'm not at even the stage of pulling the data into a report or tiles, I'm just at the point where I'm pulling it in and doing some ETL.
anyhow, let me know how I can help you further. cheers!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I was able to cobble together a screenshot of what I'm talking about. The behavior in this case is seen in IntroYear frield.
Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize.
If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.
- choose modeling tab
- select you field
- on default summarizatio, click drop down arrow next to sum and choose "don't summarize"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
108 | |
76 | |
63 |
User | Count |
---|---|
273 | |
129 | |
123 | |
101 | |
91 |