Forum Discussion
NigelP99
3 years agoRegular Visitor
Creating A Simple graph using two columns of a Dataverse Table
Hi I have a very simple dataverse table consisting of a Date Time field "Created On" and a Numeric field called "Temperature". I want PowerBI to have the "Created on" on the X-Axis and the "Tem...
- 3 years ago
Yes, you're missing the fact that in visual you need to give Power BI context of aggregation. In your case even if you will put the AVG/SUM to the field - it will return the value of the field.
SUM(17,2) is 17,2
AVERAGE(17,2) is still 17,2
Doesn't matter if you will use SUM or AVG - it will return its value.
bolfri
3 years agoSolution Sage
Yes, you're missing the fact that in visual you need to give Power BI context of aggregation. In your case even if you will put the AVG/SUM to the field - it will return the value of the field.
SUM(17,2) is 17,2
AVERAGE(17,2) is still 17,2
Doesn't matter if you will use SUM or AVG - it will return its value.