Forum Discussion
Average
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?
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?
Is your data set to a number format?
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
3 Replies
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?
Is your data set to a number format?
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