Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
I have very basic data set with 3 cols -- date time stamp and 2 temparatures fields defined as decimal number.
I want to display the variance in temps agains timestamps in a line chart but when I try to use temp on y axis it always shows count of rather than acutal values. The data type of timestamp is date time which temp is decimal.
Kindly help solve this.
Solved! Go to Solution.
Hi @panks ,
Just change the aggregation to SUM, since you only have one value for each timestamp you will get the correct value.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @panks ,
Just change the aggregation to SUM, since you only have one value for each timestamp you will get the correct value.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsVote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 112 | |
| 108 | |
| 39 | |
| 34 | |
| 27 |