Matrix with average , graph

Question

Hi All,&nbsp;I enjoy doing power BI and would like to add more graphs!&nbsp;I have a table with month, branch and sales.(1) I created a matrix in vizualization.&nbsp;I would like to see average instead of total (2)&nbsp;and create a graph(3).&nbsp;It appeas I can not get average and create the graph based on matrix?&nbsp;What is best approach to solve the solution? Thank you all for your help.&nbsp;&nbsp;All the best,cocomy&nbsp;&nbsp;

ashish_mathur · Answer

Hi,&nbsp;I can get the Table (2) for your (from Table (1)).&nbsp; However, i do not know how to plot the Grand Total row (where you want the Average) on the Graph.&nbsp; If that is OK with you, then share the link from where i can download your data.

cocomy · Answer

Hello&nbsp;Thank you very much for trying.&nbsp;As I mentioned, I want to compare sales by month, by branch in the graph.&nbsp;Here is a link of my example table.https://1drv.ms/x/s!Aknc1y0x4jcCbOR6foDoIGO802g&nbsp;All the best,cocomy&nbsp;&nbsp;

bi-lingual · Answer

Hi cocomy, Try using "Line and Stacked / clustered column chart". I've created a similar one using your data.&nbsp;

cocomy · Answer

HI BI-Lingual,&nbsp;Thank you for your suggestion.&nbsp; I want see them in lines idealy.&nbsp; Appreciate your try!&nbsp;All the bset,cocomy&nbsp;&nbsp;

Forum Discussion

Matrix with average , graph

4 Replies

Related content

Line Graph With Matrix

average on matrix

Matrix Average Column

Matrix subtotal average

DAX averages in a matrix