Forum Discussion

cocomy's avatar
cocomy
Resolver I
8 years ago

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 ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

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's avatar
    cocomy
    Resolver I
    8 years ago

    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's avatar
      BI-lingual
      Frequent Visitor
      8 years ago

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

       

      • cocomy's avatar
        cocomy
        Resolver I
        8 years ago

        HI BI-Lingual,

         

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

         

        All the bset,

        cocomy