Replacing blank with average value in matrix visuals.

Question

Hi guys,I am new in Power BI and trying to find a way to replace blank cells with average value in matrix visuals.&nbsp;Then I can calculate the total prices and compare differents products.Here is a sample:&nbsp;Appreciate every suggestions for me.Regards,Izzy

v-eachen-msft · Answer

Hi&nbsp;Izzy&nbsp;,
&nbsp;
Here is my test file, you can download and refer to it.

&nbsp;

izzy · Answer

It seems like very similar to this questions.https://community.powerbi.com/t5/Desktop/Replacing-blank-cells-in-Matrix-visuals/m-p/612814#M292062

izzy · Answer

Hi&nbsp;v-eachen-msft,&nbsp;It looks close, but the last total is still a little questionable. The last row's sum is incorrect(40 + 30 + 20 + 78 + 52 != 245). I am blocked there. Any suggestions?&nbsp; &nbsp;&nbsp;

izzy · Answer

HI v-eachen-msft&nbsp;,Any other Suggestions?&nbsp;Regards,Izzy

Forum Discussion

Replacing blank with average value in matrix visuals.

4 Replies

Related content

Replace blank with 0 in matrix visual

Replace divide by Average

Average and Moving Average

Weekly Average

Accumulated average