Forum Discussion

Swetha_24's avatar
Swetha_24
Frequent Visitor
2 years ago

How to Create a Line Chart with Multiple Material Codes and Total Quantity in Power BI

Hello, i need assistance with creating a dynmic line chart in power bi. I have a dataset with the following columns: date, material code and quantity. My goal is to create a line chart that updated ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Swetha_24 

 

Could you please provide me with some sample data and the results based on sample data? That would be very helpful. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account. Thank you for your time and efforts in advance.

 

Best Regards,
Yulia Xu

Swetha_24's avatar
Swetha_24
Frequent Visitor
2 years ago

 

Hi @Yulia Xu

Here is the sample data for reference

 

 

Currently, my line chart only shows the total quantity line, but I want to display separate lines for each selected material code along with the total quantity line for the selected material codes.

Best Regards,

Swetha