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

Remove Created on from legend.

Make sure to use dates on Y-axis, not only Time value.

NigelP99's avatar
NigelP99
Regular Visitor
3 years ago

Hi bolfri 

Why use dates on Y axis ?

 

I want my date / time to run along the bottom (x-axis)

 

Regards

 

Nigel

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