Need help with sorting data to create Line Chart

[Anonymous]

Hi everyone,

Forgive me if this sound too simple. I'm still learning PowerBi. So I have a dimension table with the following 5 columns:

SKU (consist txt SKU- primary key), SEPT, OCT, NOV, DEC (monthly sales of each data).

I have another "inventory" table with SKU as a foreign key. My goal is that I'm trying to see the trend of sales in the line chart. Maybe if I click some SKU in my "inventory" table, I could see x-axis (month) and y-axis (sales) in a line chart next to it on the same page.  

I'm hoping if anyone can help me out there or show me the way, I will really appreciate it. Thank you!

[v-shex-msft · Accepted solution]

HI @Anonymous,

Please share some detail information to help us clarify your requirement.

How to Get Your Question Answered Quickly

BTW, I think you need to do 'unpivot columns' on your table before create visual, it is hard to use current table structure to create line chart with your requirement.

Unpivot columns (Power Query)

Regards,

Xiaoxin Sheng