Forum Discussion

lvanam's avatar
lvanam
Frequent Visitor
9 years ago
Solved

Dashboard to show trending volume

All the Power BI desktop experts – Need help!!!

 

The requirement seems to be simple but I am still learning power BI desktop and struggling how to do it. Please help me.

The requirement is to show the trending of product volumes over a period of time. And the classes for the volume need to be classified as <10,10-25,26-40 and 40+.

Input data - Product, period and volume. The current visualization I made shows the classification for all the 3 years. But I want to see how the classification was for 2014, 2015 and 2016 for each month and show the trend on how it varied.

 

I have attached the sample data and the PBIX file I made for your reference. Thank you for your help.

 

3 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    Hi There,

     

    Please see the solution in attached PBIX file. 

     

     

    Thanks & Regards,

    Bhavesh

    • lvanam's avatar
      lvanam
      Frequent Visitor
      9 years ago

      Thank you Bhavesh. Do you have a single PBIX file that you can attach here? When I open the downloads, it shows me lot of files and I am not sure where the PBIX is. Thank you.