Forum Discussion

Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago

Not showing as average

HI All,   I have an issue where a column of numbers is not showing as an average.   Q1 Answer, Q2 Answer and Q3 Answer all all number.   Q1&2 both have the symbol but Q3 does not. Any idea why?...
Need Help
Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago

HI,

 

They are set to numbers

But its still showing as same after a refresh.

Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago

Hi,

 

I have tried to do a measure and got the following error when trying to use the Card visual

 

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Beiffon,

     

    From the error message, it looks like the column data type is Text. Please ensure the data type of Q1, Q2 and Q3 columns are all set to Whole Number or Decimal Number after loaded into desktop.

     

    Best regards,

    Yuliana Gu

  • BalaVenuGopal's avatar
    BalaVenuGopal
    Resolver I
    8 years ago

    Hi Beiffon ,

     

    The data type of  column which you are using in the measure is not number data type .Please make sure that the data type of column is Number .

     

     

     

    Regards,

    Venu Gopal