Forum Discussion

lvanam's avatar
lvanam
Frequent Visitor
10 years ago
Solved

Visualization for trending data over 3 years at month level

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's avatar
    ankitpatira
    10 years ago

    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.

1 Reply

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    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.