Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now
all i want is a line graph of the original tabled information
i get the options to have sum, average, maximum, Count(Distinct), Count Standard deviation, Variance, Medium,
why can i not just have a number
set as whole number set as don't summarise
please help
Hi @MB3000,
AFAIK, most of chart value fields will be aggregated based on current axis and legend category. (You can't ingore this aggerate)
If you will display detailed records, please use table visual with 'do not summarize' mode or add more category fields to your chart to keep each record has a unique id.
Regards,
Xiaoxin Sheng
Found it, sum is the value i just need to change to date
Check out the April 2026 Power BI update to learn about new features.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 42 | |
| 37 | |
| 35 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 67 | |
| 58 | |
| 29 | |
| 27 | |
| 25 |