Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I'm creating my first visualization. My query shows enrollment numbers (students enrolled in a school) by month and year. When I go to create the visualization, the data automatically sums. I don't want it to sum, I want it to show the acutal enrollment numbers I have listed. How do I get it to NOT sum?
Thanks in advance!
Hi @kcopeland ,
Actually, the value will be aggregated when you create most of the visualizations in power bi.
As I know, we only could show the raw data without sum with table visual currently in power bi.
Best Regards,
Cherry
Click on the field you need (enrollment numbers) on the far right, then go to the modeling tab and you'll see "default summarization". Select "don't summarize" from the drop down and you'll be all set!
Thanks for the quick response! Now it gives me the “count” instead of the actual number. Thoughts?
Have you verified the data type of the column of data you are using?
Also, recheck the do not summarize because that same aggregate/non-aggregate area has a count and a distinct count. Double checking never hurts and we have all clicked a little too quickly and caught the wrong selection at one time or another. You can do this from the visual by clicking the drop down area by the field name and selecting do not summarize there for the actual visual.
Proud to be a Super User!
Can you share an example of your visualization and data?
I changed the summarization to "don't summarize" so now its counting. I just want the raw data. How do I get that? Thanks for your help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |