Forum Discussion
Sales Analysis using Power BI
Use case- We have many automotive parts that are being sold by us. We have grouped them into 2 groups. Top 20 and then rest of the parts The requirement is that I want to see when we have a good or...
Thanks amitchandak . I have been trying to do that. See the image attached. What I am getting confused about is how to depict this whole relationship in the graph. Columns would be for sales of the part and what about the value of the line? Will it be the simple average of the sales, sum of the sales of each part, or a rolling average of the sales or YTD of sales or MTD sales.
I appreciate your time and help!!
Anonymous , rolling, YTD , SUM, AVG, this two much for a single chart. Can you share sample data in table format? Or a sample pbix after removing sensitive data. I will try
Refer to theme gallery if that give you new idea
https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery/