How to depict the real value not the average of values

[ace424]

I am trying to plot an "actual vs. predicted" chart on Power BI. Unfortunately, I do not see any way how to depict a bunch of real values with respect to time of the day (x axis) instead of the average of both the actuals and predicted which is now being displayed? Attached are the images of my chart, the fields settings and my actual set of fields (tables) that data is being pulled from.

In actuals_preds table, my "Date" column is of type Date, "Time" column is Time, "actuals" is Decimal Number amd "predicteds" is Whole Number.

Is there any way I can get the actual values to be shown on screen without transforming it (like std dev, sum, count, avg, etc.)? Pointers to proceed would be appreciated.

[v-yuezhe-msft · Accepted solution]

@ace424，

When you drag numerical fields to Values section of Line chart, fields will be aggregated by default. If you have different time values for same day in your table, you are able to see actual value when clicking the third drill-down button.


Alternatively, you can create a table visual using these fields, then choose “Don’t summarize” for actuals  and predicteds fields.

Regards,
Lydia

[parry2k]

you can use max or min and if you have lowest unit on your x axis, you will get actual value. (or look like actual value), you have to have the lower denomiator on x axis to see the actual value.