Visualization for trending data over 3 years at month level

[lvanam]

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.

[ankitpatira · Accepted solution]

@lvanam Extract Year out of your date column so create calculated column under Modelling tab as =Year(dateColumn) and then use that column for Legend area of your chart.