cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cocomy Member
Member

Matrix with average , graph

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.

2018_03_10_TESTPNG.PNG

 

 

All the best,

cocomy

 

 

4 REPLIES 4
Super User
Super User

Re: Matrix with average , graph

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 Member
Member

Re: Matrix with average , graph

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 Frequent Visitor
Frequent Visitor

Re: Matrix with average , graph

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

 

line-stacked-column-chart.JPG

cocomy Member
Member

Re: Matrix with average , graph

HI BI-Lingual,

 

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

 

All the bset,

cocomy

 

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 306 members 3,150 guests
Please welcome our newest community members: