Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cocomy
Resolver I
Resolver I

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
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

 

 

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

 

line-stacked-column-chart.JPG

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.