Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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!!

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

If you have any problem implementing this solution, feel free to share screenshots or error message partly.

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-juanli-msft ,

    Thanks a lot for the help and sorry for responding late. I have asked for some more details from the concerned. Once I get the data and play around with it, I can share the details with you.

     

     

    Warm regards,

    Bibhu