Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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.
Regards,
Xiaoxin Sheng
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.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |