How to create in line and stacked chart using below 2 tables

[Grace1]

Hi

How to create in line and stacked chart using below 2 tables as in the attach photo example.

[Grace1]

I can't  find the function to insert a file. 

Only has below functions :

1) Insert a spoiler tag

2) Insert code

3) Insert emoticon

4) Insert/Edit link

5) Insert/Edit image

Can advice how to insert a file ? Thanks .

[danextian]

Hi @Grace1

A well-structed question

We would prefer it if you posted an importable sample data instead of a picture. Also please, give a detailed description of your concern, how your tables relate to each other and how your values are computed.

[Grace1]

Hi

I am new to Power BI and this community. I can't find how to attach a file to this post.

I want to have a visual with Actual Price vs Budget by Customer & by Month wise. 

Price will sum per Customer by Month wise. There are 12 months budget per customer wise.

[v-chuncz-msft]

@Grace1,

You may refer to the attached sample.

[Grace1]

Hi Sam

Thanks so much for your sample. 

I try base on your sample but some how ''Shared axis" of Year and Month don't seem to appear in the visual and
sort only appear  "Sort By Customer" but not "Sort By Customer Year Month" as in your sample.

Any advice appreciated.  Thanks.

[danextian]

Hi @Grace1,

Clilck this button  until your desired granularity is shown.  

More information on drilling down can be found at this link: https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-drill-down

[Grace1]

Thanks danextian, got it !

[v-chuncz-msft · Accepted solution]

@Grace1,

By the way, you may help accept solution. Your contribution is highly appreciated.

[Grace1]

Price Table Budget Table

Customer Month    Price                  Customer Month              Budget

     A        1/1/2017   1                        A           1 January 2017   10                                                                                                       A        5/1/2017   2                        A           1 February 2017 15

     A       31/1/2017  3                        B           1 January 2017   10

     B       2/1/2017    4                        B           1 February 2017  20

     B      10/1/2017   5                        C           1 January 2017   20

     B      25/1/2017   6                                                                                                                                                                           C     10/1/2017    7

     C     29/1/2017    8

     A       2/2/2017    9

     A     28/2/2017  10

     B     14/2/2017  30

     B     28/2/2017    5                                                                                                                                                                         

Want to display below  Line and stacked column chart  format with customer and month  in the y-axis and x-axis as price and budget :

             A              B                                                                                                                                                                           35

   30

   25

   20

   15

   10

     5    Jan  Feb   Jan Feb

Want  to know is it possible to do such visuals ? Thanks.