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,
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.
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
Hi @cocomy, Try using "Line and Stacked / clustered column chart". I've created a similar one using your data.
Thank you for your suggestion. I want see them in lines idealy. Appreciate your try!
All the bset,
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.