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

PowerBIUser3's avatar
PowerBIUser3
Frequent Visitor
9 years ago

Is your data set to a number format?