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
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , you can consider clustered bar visual or line clustered bar visual 

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