Forum Discussion

NigelP99's avatar
NigelP99
Regular Visitor
3 years ago
Solved

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...
  • bolfri's avatar
    bolfri
    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.