Forum Discussion

v-nankh's avatar
v-nankh
Frequent Visitor
8 years ago
Solved

Matrix - How to add a string value in a number column

I am creating a PowerBI Report with a number column which basically has Weighted Average and that I have calculated in SQL. The weighted average is calculated based on the rating and weight for each ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    You still have add new measure and change the formula like this, I was not aware if average is pre-calculated.

     

    Add following measure and use it in your report.

     

    My Average = 
var myAvg = Average(Table3[Weighted_Average])
return if(ISBLANK(myAvg), "NA", myAvg)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Glad to hear it is working, not sure if color formatting can be done as you described.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Sorry replied too quickly, i think what you can do is change values background color to grey and then conditional formatting will take care of color where applicable and NA will be grey. (I guessed it), try it.