Forum Discussion

v-flguim's avatar
v-flguim
New Member
9 years ago
Solved

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?  
  • v-flguim's avatar
    v-flguim
    9 years ago

    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's avatar
    PowerBIUser3
    9 years ago

    Is your data set to a number format?

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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