Average

[v-flguim]

I'm starting to use power bi and included a bar graphic, but I want use average into value and I only have Count as option. Someone knows how to do this, please?

[PowerBIUser3 · Accepted solution]

Is your data set to a number format?

[v-flguim · Accepted solution]

I'm starting using Power BI and I inclulded a bar graphic but I don't have option to average the value, only count. Someone knows how to do this, please?

[v-qiuyu-msft · Accepted solution]

Hi @v-flguim,

Average() function is not available to the Text data type column. You need to set the field data type as Numbers then Average aggregation will be available.

Best Regards,
Qiuyun Yu

[v-flguim · Accepted solution]

I'm starting using Power BI and I inclulded a bar graphic but I don't have option to average the value, only count. Someone knows how to do this, please?

[PowerBIUser3 · Accepted solution]

Is your data set to a number format?