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...
Need Help
  • 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.

bolfri's avatar
bolfri
Solution Sage
3 years ago

Yes. If it's decimal field then change Count to Average/Sum (as u prefer). It will work then.

NigelP99's avatar
NigelP99
Regular Visitor
3 years ago

Hi

 

I dont want Average / Sum - I just want the value of the field.

 

(or am I missing something ?)

 

Thanks

 

Nigel

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

  • NigelP99's avatar
    NigelP99
    Regular Visitor
    3 years ago

    Hi bolfri

    Thanks - thats great !¬

     

    It now works as I wanted it to.

     

    Thanks for staying with me on this one.

     

    Thanks

     

    Nigel