Matrix with average , graph

[cocomy]

Hi All,

I enjoy doing power BI and would like to add more graphs!

I have a table with month, branch and sales.(1) I created a matrix in vizualization.

I would like to see average instead of total (2) and create a graph(3).

It appeas I can not get average and create the graph based on matrix?

What is best approach to solve the solution? Thank you all for your help.

All the best,

cocomy

[Ashish_Mathur]

Hi,

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

[cocomy]

Hello

Thank you very much for trying.

As I mentioned, I want to compare sales by month, by branch in the graph.

Here is a link of my example table.
https://1drv.ms/x/s!Aknc1y0x4jcCbOR6foDoIGO802g

All the best,

cocomy

[BI-lingual]

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

[cocomy]

HI BI-Lingual,

Thank you for your suggestion.  I want see them in lines idealy.  Appreciate your try!

All the bset,

cocomy