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