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

I am sorry, I meant x-axis. 🙂 Just make sure it's a datetime, because right now it seems to be a time only.

NigelP99's avatar
NigelP99
Regular Visitor
3 years ago

Hi

 

I think the issue is that PowerBI does not like the field (Actual Temperature) I am using. As PowerBI converts to Count Of when the field is a Text field. But I am using a Dataverse table where the field is of Type "Decimal" which PowerBI should not convert to a CountOf in the Y-Axis of my Line chart.

 

Any ideas ?

 

Regards

 

Nigel

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